[SPARK-8194] date/time function: add_months

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: SQL
• Target Version/s: 1.5.0
• Sprint: Spark 1.5 release
• Assignee: Adrian Wang
• Reporter: Reynold Xin
• Created: 09/Jun/15 06:10
• Updated: 31/Jul/15 07:49
• Resolved: 30/Jul/15 20:22

Description

add_months(string start_date, int num_months): string

add_months(date start_date, int num_months): date

Returns the date that is num_months after start_date. The time part of start_date is ignored. If start_date is the last day of the month or if the resulting month has fewer days than the day component of start_date, then the result is the last day of the resulting month. Otherwise, the result has the same day component as start_date.

Issue Links

• relates to: SPARK-8864 Date/time function and data type design
• links to: [Github] Pull Request #6987 (adrian-wang)
• links to: [Github] Pull Request #7589 (adrian-wang)
• links to: [Github] Pull Request #7754 (davies)