[
https://issues.apache.org/jira/browse/HIVE-12193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez updated HIVE-12193:
-------------------------------------------
Labels: timestamp (was: )
> Add a consistent unix_timestamp function.
> -----------------------------------------
>
> Key: HIVE-12193
> URL: https://issues.apache.org/jira/browse/HIVE-12193
> Project: Hive
> Issue Type: Sub-task
> Components: Hive
> Affects Versions: 1.1.1
> Reporter: Ryan Blue
> Labels: timestamp
>
> The {{unix_timestamp}} function returns values with respect to the SQL
> session time zone (which is the default JVM time zone). This varies depending
> on server time zone. This is required by the documentation for the function
> and would be difficult to change.
> For users that want consistent results across zones, Hive should include a
> {{utc_timestamp}} method that is zone independent and gives a result assuming
> the timestamp without time zone passed in is in UTC.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
