Ryan Blue created HIVE-12194: -------------------------------- Summary: Incorrect result when using from_utc_timestamp with the local time zone. Key: HIVE-12194 URL: https://issues.apache.org/jira/browse/HIVE-12194 Project: Hive Issue Type: Sub-task Components: Hive Affects Versions: 1.1.1 Reporter: Ryan Blue
When I call the {{from_utc_timestamp}} function (or {{to_utc_timestamp}}) using my current time zone, the result is incorrect: {code} // CURRENT SERVER TIME ZONE IS PDT hive> select to_utc_timestamp('2015-10-13 09:15:34.101', 'PDT'); 2015-10-13 09:15:34.101 // NOT CHANGED! hive> select to_utc_timestamp('2015-10-13 09:15:34.101', 'PST'); 2015-10-13 16:15:34.101 // CORRECT VALUE FOR PST {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)