You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Anurag Shekhar (Jira)" <ji...@apache.org> on 2021/08/16 08:00:00 UTC
[jira] [Created] (HIVE-25451) from_utc_timestamp uses wrong
timezone offset for dates prior to 1895-12-01
Anurag Shekhar created HIVE-25451:
-------------------------------------
Summary: from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01
Key: HIVE-25451
URL: https://issues.apache.org/jira/browse/HIVE-25451
Project: Hive
Issue Type: Bug
Components: UDF
Environment: from beeline
select from_utc_timestamp('1895-12-01', 'Australia/Perth');
+------------------------+
| _c0 |
+------------------------+
| 1895-12-01 08:00:00.0 |
+------------------------+
This one is using correct offset of 8 hours.
Same query with date as 1895-11-30
select from_utc_timestamp('1895-11-30', 'Australia/Perth');
+------------------------+
| _c0 |
+------------------------+
| 1895-11-30 07:43:24.0 |
+------------------------+
Now the offset is 07:43:24.0
Reporter: Anurag Shekhar
--
This message was sent by Atlassian Jira
(v8.3.4#803005)