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)