XML Date Conversion Issue

[Anonymous]

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 ???

[Anonymous]

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 🙂