XML Date Conversion Issue

Anonymous — Tue, 26 Feb 2019 22:55:57 GMT

Hi all,

In the XML file, i get value of date column as "2019-01-10T06:35:00-04:00" . where "-04:00" is specifying time zone(GMT).

Now while converting the date using TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ssXXX",Date Column)

I am getting the result as "2019-01-10 05:35:00.000" (1 hour less than the actual).

Is there a way to fix this ???

Re: XML Date Conversion Issue

Anonymous — Wed, 27 Feb 2019 02:59:51 GMT

Hi,

I tried the fnction TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ssXXX",row1.data) and it is showing right results. The different formats can be referred from below link.

https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

But if you are looking to change the target column's date to some other format, you will need to specify it explicitly. Else it will process it with default time zone.

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 🙂

topic XML Date Conversion Issue in Talend Studio

XML Date Conversion Issue

Re: XML Date Conversion Issue