[
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)
