date Format in tFileInputDelimited error

[Anonymous]

hello everyone,

i am trying to read a csv file which contains date in this format : 2019-11-22 13:57:00+01, and i'm getting this error : 

Couldn't parse value for column 'WorkDate' in 'row1', value is '2019-03-22 16:21:00+01'. Details: java.lang.RuntimeException: Unparseable date: "2019-03-22 16:21:00+01"

can someone please told me what date pattern fits this date ?

Thanks,#tFileInputDelimited; #dateFormat

[Anonymous]

Hi,

   If you are using ISO 8601 time zone format, please use X in the date format section. Else please add the time format as +0100 so that you can use Z to specify RFC 822 time zone format.

   Please refer the different java date format options below.

https://dzone.com/articles/java-simpledateformat-guide

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous]

Hi, 

you can use the following pattern for your csv file : "yyyy-MM-dd HH:mm:ssX"

If you are +01 TimeZone (like me) note when you encounter a +02 date for example Talend will retire 1 hour to get the date back to its local format (+01 in my case)

2019-11-22 13:57:00+02 -> 2019-11-22 12:57:00+01

May this help you

Regards

Pierre