hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramesh c <rames...@hotmail.com>
Subject Getting date from_utc_timestamp with timezone parameter
Date Fri, 07 Feb 2014 14:43:12 GMT
Hi,
I am trying to get a date time for an epoch value (1391300800) for different timezones. I
am getting wrong times, it seems like converting to local timezone. How do I get the right
times.
select from_utc_timestamp(1391300800000, "America/New_York") ,from_utc_timestamp(1391300800000,
"GMT") gmt1,
from_utc_timestamp(1391300800000, "US/Eastern") est1,
from_utc_timestamp(1391300800000, "Japan") jp1
from dual2014-02-01 14:26:40	2014-02-01 19:26:40	2014-02-01 14:26:40	2014-02-02 04:26:40Thank
youRamesh 		 	   		  
Mime
View raw message