You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Sam William <sa...@stumbleupon.com> on 2011/09/19 23:19:16 UTC

Time/date functions - timezone

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