[HIVE-25451] from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Invalid
• Component/s: UDF
• Assignee: Unassigned
• Reporter: Anurag Shekhar
• Created: 16/Aug/21 07:59
• Updated: 24/Aug/21 03:22
• Resolved: 24/Aug/21 03:22

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