topic Re: JSON Unparseable date format in Talend Studio

JSON Unparseable date format

Anonymous — Wed, 09 May 2018 15:20:08 GMT

Can someone get me right date format pattern for the below date style. I get this format in my JSON.
"2018-05-08T05:54:19.360+0000"

I have tried following formats but none of them works.
"yyyy-MM-dd'T'HH:mm:ss.SSSZ"

"yyyy-MM-dd'T'HH:mm:ss.SSSx"

"yyyy-MM-dd'T'HH:mm:ss.SSSX"

Thanks

vboppudi — Wed, 09 May 2018 15:53:19 GMT

Hi,

Are you looking for the following output?

Please use : TalendDate.parseDateInUTC("yyyy-MM-dd'T'HH:mm:ss.SSS",row2.date_string)

Regards,

Anonymous — Fri, 11 May 2018 00:01:54 GMT

Hi Veeru, Thanks for the answer, but I have to parse the date in json input component, so I need the exact date format with timezone offset.

Anonymous — Wed, 04 Jul 2018 13:20:07 GMT

Hi Zahoor,

Are you able get exact date format?

vaibs_parab — Mon, 31 Jan 2022 11:25:46 GMT

Hi @Zahoor Zahoor and @Arpit Verma ,

If your date is like this "2018-05-08T05:54:19.360+0000"

then your pattern should be as follows:

"yyyy-MM-dd'T'HH:mm:ss.SSSXXX"

Please try and let me know.

Regards!