You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2013/10/06 20:05:43 UTC

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

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)