topic Re: [resolved] Convert date time string to date time string in UTC time in Talend Studio

[resolved] Convert date time string to date time string in UTC time

talendbee — Sun, 17 Jan 2016 23:04:14 GMT

Hi

I need assistance in converting a non-UTC date time string below
"2016-01-09T09:00:00+10:00"
to string with UTC date time string, for the above string I would need string as one below,
"20160108230000"

Can somebody help please.

Regards
taendbee

Re: [resolved] Convert date time string to date time string in UTC time

Anonymous — Mon, 18 Jan 2016 23:13:44 GMT

1. convert your date string into a Date object.
2. Move the timezone by adding the hours needed with TalendDate.addDate(...) <-- here you can add or subtract hours
3. convert the result date object back into you desired string format with TalendDate.formatDate(...)

Re: [resolved] Convert date time string to date time string in UTC time

talendbee — Tue, 19 Jan 2016 04:08:49 GMT

Thank you for reply. I did a test following your steps and I can get what I wanted.