You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Ramesh c <ra...@hotmail.com> on 2014/02/07 15:43:12 UTC

Getting date from_utc_timestamp with timezone parameter

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