[
https://issues.apache.org/jira/browse/HIVE-9357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14276571#comment-14276571
]
Alexander Pivovarov commented on HIVE-9357:
-------------------------------------------
>From the Oracle reference on add_months
If date is the last day of the month or if the resulting month has fewer days
than the day component of date, then the result is the last day of the
resulting month. Otherwise, the result has the same day component as date.
> Create ADD_MONTHS UDF
> ---------------------
>
> Key: HIVE-9357
> URL: https://issues.apache.org/jira/browse/HIVE-9357
> Project: Hive
> Issue Type: Improvement
> Components: UDF
> Reporter: Alexander Pivovarov
> Assignee: Alexander Pivovarov
> Attachments: HIVE-9357.1.patch
>
>
> ADD_MONTHS adds a number of months to startdate:
> add_months('2015-01-14', 1) = '2015-02-14'
> add_months('2015-01-31', 1) = '2015-02-28'
> add_months('2015-02-28', 2) = '2015-04-30'
> add_months('2015-02-28', 12) = '2016-02-29'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
