[jira] [Created] (HIVE-5472) support a simple scalar which returns the current timestamp

[N Campbell (JIRA)]

N Campbell created HIVE-5472:
--------------------------------

             Summary: support a simple scalar which returns the current 
timestamp
                 Key: HIVE-5472
                 URL: https://issues.apache.org/jira/browse/HIVE-5472
             Project: Hive
          Issue Type: Improvement
    Affects Versions: 0.11.0
            Reporter: N Campbell


ISO-SQL has two forms of functions

local and current timestamp where the former is a TIMESTAMP WITHOUT TIMEZONE 
and the latter with TIME ZONE

select cast ( unix_timestamp() as timestamp ) from T

implement a function which computes LOCAL TIMESTAMP which would be the current 
timestamp for the users session time zone.





--
This message was sent by Atlassian JIRA
(v6.1#6144)