topic Date format in Talend Studio

Date format

DrGenious — Tue, 04 Feb 2020 13:11:18 GMT

Hey,

I have a string with date "17-03-19 9:05" and I want to change the format to "yyyy-MM-dd HH:mm:ss" and the type to be string.

Also I want to convecrt 'May 20 2019 15:30:02 GST" to "yyyy-MM-dd HH:mm:ss"

Please help me.Thanks.

Re: Date format

Anonymous — Tue, 04 Feb 2020 14:37:40 GMT

You will need to use the TalendDate routines for this (....or use standard Java Date functionality...but the TalendDate routines make it easier). These are described here....

https://help.talend.com/reader/QrWkwPvKmKybs~JNLeBt3Q/GF6kKOHdJwnnbGY_b6u02g

Re: Date format

DrGenious — Tue, 04 Feb 2020 14:52:51 GMT

I figure it out how to do the first one but I need help with the second "May 20 2019 15:30:02 GST "

Re: Date format

Anonymous — Tue, 04 Feb 2020 15:09:53 GMT

This code will do it....

String strDate = "May 20 2019 15:30:02 GST ";

Date date = routines.TalendDate.parseDate("MMM dd yyyy HH:mm:ss z", strDate);

System.out.println(strDate);
System.out.println(routines.TalendDate.formatDate("yyyy-MM-dd HH:mm:ss", date));

This page will make figuring this sort of stuff out a bit easier.....

https://docs.oracle.com/javase/10/docs/api/java/text/SimpleDateFormat.html