Ashish Sharma created HIVE-25458:
------------------------------------
Summary: combination of from_unixtime and unix_timestamp is giving
wrong result
Key: HIVE-25458
URL: https://issues.apache.org/jira/browse/HIVE-25458
Project: Hive
Issue Type: Bug
Reporter: Ashish Sharma
Description -
set hive.local.time.zone=Asia/Bangkok;
select from_unixtime(unix_timestamp('1400-11-08 01:53:11'));
Result - 1400-11-17 01:35:15
Expected - 1400-11-08 01:53:11
select from_unixtime(unix_timestamp('1800-11-08 01:53:11'));
Result - 1800-11-08 01:35:15
Expected - 1800-11-08 01:53:11
select from_unixtime(unix_timestamp('1400-11-08 08:00:00 ICT', 'yyyy-MM-dd
HH:mm:ss z'));
Result 1400-11-17 07:42:04
Expected 1400-11-08 08:00:00
select from_unixtime(unix_timestamp('1800-11-08 08:00:00 ICT', 'yyyy-MM-dd
HH:mm:ss z'));
Result - 1800-11-08 07:42:04
Expected - 1800-11-08 08:00:00
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
