hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrey Zinovyev (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-21067) TO_UNIX_TIMESTAMP (or UNIX_TIMESTAMP) treats argument timestamp as UTC
Date Tue, 25 Dec 2018 10:02:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-21067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Andrey Zinovyev updated HIVE-21067:
-----------------------------------
    Description: 
In previous versions (at least in 1.2) we had 


 > SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");
 1545692453



Now it is


 > SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");
 1545703253 



We're in +3 timezone (Europe/Moscow)

This changes was made in HIVE-12192. I don't know if it was intentional, but according to
[wiki|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions] unix_timestamp
should use default timezone 

 

 

  was:
In previous versions (at least in 1.2) we had 


{{> SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");}}
{{ 1545692453}}


 Now it is


{{ > SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");}}
{{1545703253 }}


 We're in +3 timezone (Europe/Moscow)

This changes was made in HIVE-12192. I don't know if it was intentional, but according to
[wiki|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions] unix_timestamp
should use default timezone 

 

 


> TO_UNIX_TIMESTAMP (or UNIX_TIMESTAMP) treats argument timestamp as UTC
> ----------------------------------------------------------------------
>
>                 Key: HIVE-21067
>                 URL: https://issues.apache.org/jira/browse/HIVE-21067
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.1.0
>            Reporter: Andrey Zinovyev
>            Priority: Minor
>
> In previous versions (at least in 1.2) we had 
>  > SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");
>  1545692453
> Now it is
>  > SELECT TO_UNIX_TIMESTAMP("2018-12-25 02:00:53.297");
>  1545703253 
> We're in +3 timezone (Europe/Moscow)
> This changes was made in HIVE-12192. I don't know if it was intentional, but according
to [wiki|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions] unix_timestamp
should use default timezone 
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message