[jira] [Created] (HIVE-14161) from_utc_timestamp()/to_utc_timestamp return incorrect results with EST

["Chaoyu Tang (JIRA)" <ji...@apache.org>]

Chaoyu Tang created HIVE-14161:
----------------------------------

             Summary: from_utc_timestamp()/to_utc_timestamp return incorrect results with EST
                 Key: HIVE-14161
                 URL: https://issues.apache.org/jira/browse/HIVE-14161
             Project: Hive
          Issue Type: Bug
          Components: UDF
            Reporter: Chaoyu Tang
            Assignee: Chaoyu Tang


{code}
hive> SELECT to_utc_timestamp('2016-06-30 06:00:00', 'PST'); 
OK
2016-06-30 13:00:00  ==>Correct, UTC is 7 hours ahead of PST
Time taken: 1.674 seconds, Fetched: 1 row(s)
hive> SELECT to_utc_timestamp('2016-06-30 08:00:00', 'CST');
OK
2016-06-30 13:00:00  ==>Correct, UTC is 5 hours ahead of CST
Time taken: 1.776 seconds, Fetched: 1 row(s)
hive> SELECT to_utc_timestamp('2016-06-30 09:00:00', 'EST');
OK
2016-06-30 14:00:00  ==>Wrong, UTC should be 4 hours ahead of EST
Time taken: 1.686 seconds, Fetched: 1 row(s)
hive> select from_utc_timestamp('2016-06-30 14:00:00', 'EST');
OK
2016-06-30 09:00:00  ==>Wrong, UTC should be 4 hours ahead of EST
{code}
It might be something related to daylight savings time.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)