hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-313) add UDF date_add, date_sub, datediff
Date Fri, 27 Feb 2009 06:18:01 GMT

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

Zheng Shao commented on HIVE-313:
---------------------------------

{code}

DATE_ADD('2009-01-01', 1) = '2009-01-02'
DATE_SUB('2009-01-01', 1) = '2008-12-31'

DATEDIFF('2009-01-01', '2008-12-31') = 1

{code}


> add UDF date_add, date_sub, datediff
> ------------------------------------
>
>                 Key: HIVE-313
>                 URL: https://issues.apache.org/jira/browse/HIVE-313
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Zheng Shao
>
> See http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add
> See http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-sub
> See http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_datediff

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message