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/24 03:23:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=17403489#comment-17403489 ]
Anurag Shekhar commented on HIVE-25451:
---------------------------------------
As per timezone data from IANA this is correct conversion.
> 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
>
> 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
--
This message was sent by Atlassian Jira
(v8.3.4#803005)