[
https://issues.apache.org/jira/browse/HIVE-7449?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jason Dere resolved HIVE-7449.
------------------------------
Resolution: Not A Problem
> from_utc_timestamp and to_utc_timestamp not returning right values
> ------------------------------------------------------------------
>
> Key: HIVE-7449
> URL: https://issues.apache.org/jira/browse/HIVE-7449
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.10.0, 0.12.0
> Reporter: Mala Chikka Kempanna
>
> Tested it out like below
> 1.Get UTC and local time
> date -u
> Fri Jul 18 18:15:29 UTC 2014
> Local time
> date
> Fri Jul 18 11:15:32 PDT 2014
> 2. Conversion output on HIVE 0.10.0 and HIVE 0.12.0
> From UTC to local
> SELECT from_utc_timestamp('2014-07-18 18:15:29.0','PDT') FROM sample_07 LIMIT
> 1;
> 2014-07-18 18:15:29 - Wrong output , it is supposed to be 2014-07-18 11:15:32
> From local to utc
> SELECT to_utc_timestamp('2014-07-18 11:15:32.0','PDT') FROM sample_07 LIMIT
> 1;
> 2014-07-18 11:15:32 - Wrong output , it is supposed to be 2014-07-18 18:15:29
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)