You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Anurag Shekhar (Jira)" <ji...@apache.org> on 2021/08/23 05:54:00 UTC
[jira] [Updated] (HIVE-25451) from_utc_timestamp uses wrong
timezone offset for dates prior to 1895-12-01
[ https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anurag Shekhar updated HIVE-25451:
----------------------------------
Environment: (was: 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)
> 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
> Reporter: Anurag Shekhar
> Priority: Minor
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)