You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Ashish Sharma (Jira)" <ji...@apache.org> on 2021/08/17 11:21:00 UTC

[jira] [Created] (HIVE-25458) combination of from_unixtime and unix_timestamp is giving wrong result

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)