mark.pundurs@... 2013-06-07, 16:49
-Re: HQL *_utc_timestamp functions' timezone parameter?
Matt Tucker 2013-06-07, 20:14
I ran into the same issue last week, and ended up writing a small app to
print the results of
Having to convert from GMT to Pacific Time (accounting for Daylight Saving
Time), I used "PST8PDT". You may need to multiple your unix timestamp by
1000 for the *_utc_timestamp functions, as the Timestamp datatype appears
to be counting in milliseconds.
On Fri, Jun 7, 2013 at 9:49 AM, <[EMAIL PROTECTED]> wrote:
> The HQL *_utc_timestamp functions' timezone parameter appears to be
> documented only as far as noting its existence. What are its allowed
> values? Does it make any attempt to account for daylight savings time aka
> summer hours? (If so, should that attempt be trusted?)
> Thanks in advance!
> Mark Pundurs
> Senior Data Analyst - Traffic