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