[
https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar updated HIVE-25451:
----------------------------------
Description:
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
>
> 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)
