parseDateInUTC and formatDateInUTC behave differently

Papademuchos — Sat, 16 Nov 2024 01:24:00 GMT

parsedateInUTC and formatDateInUTC seem to behave differently.

First, I'm in the Pacific Time Zone. So 12 pm PST is 7 pm UTC.

If I do this: TalendDate.parseDateInUTC("yyyy-MM-dd HH:mm:ss","2020-09-23 12:00:00"), I get 23-09-2020 05:00:00, which is incorrect. It's 7 hours backwards instead of forwards.

But if I do this (at 12 pm today):

TalendDate.formatDateInUTC("yyyy-MM-dd HH:mm:ss", TalendDate.getCurrentDate() ), I get 2020-09-23 19:00:00, which is correct.

If I want a string date passed in converted to the correct UTC date, I have to do this:

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss",

TalendDate.formatDateInUTC("yyyy-MM-dd HH:mm:ss",

TalendDate.parseDate("yyyy-MM-dd HH:mm:ss","2020-09-23 12:00:00")))

which is crazy - why do I have to parse date twice? why won't parseDateInUTC work? What am I missing?

Thanks in Advance!

Re: parseDateInUTC and formatDateInUTC behave differently

Jesperrekuh — Mon, 28 Sep 2020 11:54:19 GMT

For those who often forget , AM and PM, java HH is 00-23 and hh 01-12.

myJavaUtilDate.toInstant().toString() // Example: '2020-07-03T10:15:30.120Z'

The toString implementation uses the DateTimeFormatter.ISO_INSTANT format by default

Look at java's TimeZone format.

And at stackoverflow

topic parseDateInUTC and formatDateInUTC behave differently in Talend Studio

parseDateInUTC and formatDateInUTC behave differently

Re: parseDateInUTC and formatDateInUTC behave differently