Four Stars

JSON Unparseable date format

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

3 REPLIES
Nine Stars

Re: JSON Unparseable date format

Hi,

 

Are you looking for the following output?

DateParse.PNG

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

 

Regards,

Veeru Boppudi
Four Stars

Re: JSON Unparseable date format

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.

Five Stars

Re: JSON Unparseable date format

Hi Zahoor,

Are you able get exact date format?