topic Re: [resolved] Get UTC date in Talend Studio

[resolved] Get UTC date

alevy — Thu, 02 Aug 2012 14:09:14 GMT

Please could someone tell me the easiest way to get the current UTC time in the format yyyy-MM-dd HH:mm:ss.SSS. I can't for the life of me figure it out for some reason.

Re: [resolved] Get UTC date

janhess — Thu, 02 Aug 2012 14:28:07 GMT

Do you want to convert a time zone to GMT?
From Wikipedia
Time zones are usually defined to differ from UTC by an integer number of hours, although the laws of each jurisdiction would have to be consulted if sub-second accuracy was required. Several jurisdictions have established time zones that differ by an integer number of half-hours or quarter-hours from UT1 or UTC.
The UTC time zone is sometimes denoted by the letter Z?a reference to the equivalent nautical time zone (GMT), which has been denoted by a Z since about 1950.

Re: [resolved] Get UTC date

alevy — Thu, 02 Aug 2012 15:46:08 GMT

Yes, I suppose. I want the equivalent of TalendDate.getDate("yyyy-MM-dd HH:mm:ss.SSS") but where the result is the time in UTC rather than my default timezone i.e. if I call the expression at 11pm in my +10 timezone then the result would be "2012-08-02 13:00:00.000" and needs to factor in local DST when applicable.

Re: [resolved] Get UTC date

janhess — Thu, 02 Aug 2012 16:12:57 GMT

Found this on the web. It's a web service for UTC time.
http://www.nanonull.com/TimeService/TimeService.asmx?op=getOffesetUTCTime
There's also a getUTCTime.

Re: [resolved] Get UTC date

alevy — Thu, 02 Aug 2012 16:27:12 GMT

Surely there's a way to do it with Java?

Re: [resolved] Get UTC date

alevy — Fri, 03 Aug 2012 01:08:52 GMT

I did it like this, which seems to work, including accounting for daylight saving

Calendar c = Calendar.getInstance();
TimeZone tz = c.getTimeZone();
Long ms = c.getTimeInMillis();
Date dt = new Date(ms-tz.getOffset(ms));

Note that c.getTime() always gives local time, even if c is instantiated with a different TimeZone.

Re: [resolved] Get UTC date

_AnonymousUser — Fri, 14 Oct 2016 01:23:11 GMT

For reference, it is easier and better to use TalendDate.formatDateInUTC

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

Re: [resolved] Get UTC date

alevy — Wed, 02 Nov 2016 01:09:42 GMT

Which was added in v6.0.1.