You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "slim bouguerra (JIRA)" <ji...@apache.org> on 2018/12/25 15:55:00 UTC
[jira] [Commented] (HIVE-21067) TO_UNIX_TIMESTAMP (or
UNIX_TIMESTAMP) treats argument timestamp as UTC
[ https://issues.apache.org/jira/browse/HIVE-21067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16728756#comment-16728756 ]
slim bouguerra commented on HIVE-21067:
---------------------------------------
I don't think the wiki should be the reference point, It is better if we stick with the SQL Standard thought.
> 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)