hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sam William <>
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

View raw message