Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
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
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