[
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)
