[HIVE-9358] Create LAST_DAY UDF

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: UDF
• Release Note: Returns the last day of the month which the date belongs to.
• Assignee: Alexander Pivovarov
• Reporter: Alexander Pivovarov
• Created: 13/Jan/15 03:43
• Updated: 12/Feb/15 23:41
• Resolved: 19/Jan/15 19:52

Description

LAST_DAY returns the date of the last day of the month that contains date:
last_day('2015-01-14') = '2015-01-31'
last_day('2016-02-01') = '2016-02-29'

last_day function went from oracle http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions072.htm