[jira] Commented: (HIVE-313) add UDF date_add, date_sub, datediff

["Zheng Shao (JIRA)" <ji...@apache.org>]

    [ 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.