You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "caofangkun (JIRA)" <ji...@apache.org> on 2013/01/25 07:55:14 UTC
[jira] [Updated] (HIVE-3942) Add UDF month_add and month_sub
[ 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