JSON Unparseable date format

[Anonymous]

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]

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]

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]

Hi Zahoor,

Are you able get exact date format?

[vaibs_parab]

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!