hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Dere (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-12706) Incorrect output from from_utc_timestamp()/to_utc_timestamp when local timezone has DST
Date Thu, 17 Dec 2015 20:07:46 GMT
Jason Dere created HIVE-12706:
---------------------------------

             Summary: Incorrect output from from_utc_timestamp()/to_utc_timestamp when local
timezone has DST
                 Key: HIVE-12706
                 URL: https://issues.apache.org/jira/browse/HIVE-12706
             Project: Hive
          Issue Type: Bug
          Components: UDF
            Reporter: Jason Dere
            Assignee: Jason Dere


Getting wrong output with the local timezone set to PST (which has DST). I don't think this
happens when the local timezone does not observe DST.

{noformat}
select from_utc_timestamp('2015-03-28 17:00:00', 'Europe/London')
2015-03-28 17:00:00

select from_utc_timestamp('2015-03-28 18:00:00', 'Europe/London')
2015-03-28 19:00:00  <= Wrong, should be 2015-03-28 18:00:00

select from_utc_timestamp('2015-03-28 19:00:00', 'Europe/London')
2015-03-28 20:00:00 <= Wrong, should be 2015-03-28 19:00:00
{noformat}

Also to_utc_timestamp():
{noformat}
select to_utc_timestamp('2015-03-28 17:00:00', 'Europe/London')
2015-03-28 17:00:00

select to_utc_timestamp('2015-03-28 18:00:00', 'Europe/London')
2015-03-28 17:00:00 <= Wrong

select to_utc_timestamp('2015-03-28 19:00:00', 'Europe/London')
2015-03-28 18:00:00 <= Wrong

select to_utc_timestamp('2015-03-28 20:00:00', 'Europe/London')
2015-03-28 19:00:00 <= Wrong
{noformat}



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

Mime
View raw message