[HIVE-14305] To/From UTC timestamp may return incorrect result because of DST

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: timestamp
• Assignee: Rui Li
• Reporter: Rui Li
• Created: 21/Jul/16 06:32
• Updated: 05/Dec/22 09:56

Description

If the machine's local timezone involves DST, the UDFs return incorrect results.
For example:

select to_utc_timestamp('2005-04-03 02:01:00','UTC');

returns 2005-04-03 03:01:00. Correct result should be 2005-04-03 02:01:00.

select to_utc_timestamp('2005-04-03 10:01:00','Asia/Shanghai');

returns 2005-04-03 03:01:00. Correct result should be 2005-04-03 02:01:00.