[HIVE-9357] Create ADD_MONTHS UDF

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: UDF
• Release Note: Returns the date that is num_months after start_date
• Assignee: Alexander Pivovarov
• Reporter: Alexander Pivovarov
• Created: 13/Jan/15 03:41
• Updated: 18/May/15 20:45
• Resolved: 19/Jan/15 19:44

Description

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'

Issue Links

• duplicates: HIVE-3942 Add UDF month_add and month_sub