Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> HQL *_utc_timestamp functions' timezone parameter?

Copy link to this message
Re: HQL *_utc_timestamp functions' timezone parameter?
Hi Mark,

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.

Good luck!
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
> Chicago