You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Priyadarshini (Commented) (JIRA)" <ji...@apache.org> on 2011/12/16 07:11:30 UTC

[jira] [Commented] (HIVE-2019) Implement NOW() UDF

    [ https://issues.apache.org/jira/browse/HIVE-2019?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13170798#comment-13170798 ] 

Priyadarshini commented on HIVE-2019:
-------------------------------------

I am working on this.
I have few doubts to clarify with respect to this.
select now(),now() from <tname>
The above query shud return the same time in both ofthe columns ? I find that in the reference link it does it.
One more doubt is if we want of this format,
select now()+0 from <tname>
i.e adding some integers to the now() function, it shuould be possible that now() fucntion should take argument like which format user want.
So for operations for adding some integer to now() funciton, we may hav to pass the format also
                
> Implement NOW() UDF
> -------------------
>
>                 Key: HIVE-2019
>                 URL: https://issues.apache.org/jira/browse/HIVE-2019
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>            Reporter: Carl Steinbach
>
> Reference: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_now

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira