[
https://issues.apache.org/jira/browse/HIVE-3942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
caofangkun updated HIVE-3942:
-----------------------------
Attachment: HIVE-3942-1.patch
> Add UDF month_add and month_sub
> --------------------------------
>
> Key: HIVE-3942
> URL: https://issues.apache.org/jira/browse/HIVE-3942
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Affects Versions: 0.9.0
> Reporter: caofangkun
> Priority: Minor
> Attachments: HIVE-3942-1.patch
>
>
> hive (default)> desc function extended month_add;
> month_add(start_date, num_months) - Returns the date that is num_months after
> start_date.
> Synonyms: month_sub
> start_date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
> num_months is a number. The time part of start_date is ignored.
> Example:
> SELECT month_add('2012-04-12', 1) FROM src LIMIT 1; --Return 2012-05-12
> SELECT month_add('2012-04-12 11:22:31', 1) FROM src LIMIT 1; --Return
> 2012-05-12
> SELECT month_add(cast('2012-04-12 11:22:31' as timestamp), 1) FROM src
> LIMIT 1; --Return 2012-05-12
> hive (default)> desc function extended month_sub;
> month_sub(start_date, num_months) - Returns the date that is num_months after
> start_date.
> Synonyms: month_add
> start_date is a string in the format 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
> num_months is a number. The time part of start_date is ignored.
> Example:
> SELECT month_sub('2012-04-12', 1) FROM src LIMIT 1; --Return 2012-05-12
> SELECT month_sub('2012-04-12 11:22:31', 1) FROM src LIMIT 1; --Return
> 2012-05-12
> SELECT month_sub(cast('2012-04-12 11:22:31' as timestamp), 1) FROM src
> LIMIT 1; --Return 2012-05-12
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
