Ryan Blue created HIVE-12193:
--------------------------------
Summary: 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
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.3.4#6332)
