hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sam William <sa...@stumbleupon.com>
Subject Time/date functions - timezone
Date Mon, 19 Sep 2011 21:19:16 GMT
I have all my slave nodes  on PDT timezone.  However when I run this query  ,


select from_unixtime(unix_timestamp()) from dual;   (dual is a one row table that I created).



I get the date/time in UTC.    What do I do get the PDT time ( i dont want to write a udf
for this ) .



Sam William
sampd@stumbleupon.com




Mime
View raw message