[HIVE-25577] unix_timestamp() is ignoring the time zone value

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.1.2, 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: UDF
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Ashish Sharma
• Reporter: Ashish Sharma
• Created: 29/Sep/21 13:29
• Updated: 17/Nov/22 08:47
• Resolved: 05/Oct/21 05:09

Description

set hive.local.time.zone=Asia/Bangkok;

Query - SELECT FROM_UNIXTIME(UNIX_TIMESTAMP('2000-01-07 00:00:00 GMT','yyyy-MM-dd HH:mm:ss z'));

Result - 2000-01-07 00:00:00 ICT

Issue Links

• is caused by: HIVE-25458 unix_timestamp() with string input give wrong result
• is related to: HIVE-25559 to_unix_timestamp udf result incorrect
• links to: GitHub Pull Request #2686