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

Switch to Threaded View
Hive, mail # user - Time/date functions - timezone


Copy link to this message
-
Time/date functions - timezone
Sam William 2011-09-19, 21:19
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
[EMAIL PROTECTED]