[FLINK-26944] Add ADD_MONTHS supported in SQL and Table API

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 1.20.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: dalongliu
• Created: 31/Mar/22 07:06
• Updated: 11/Mar/24 12:44

Description

Returns the date that is numMonths after startDate.

Syntax:

add_months(startDate, numMonths) 

Arguments:

• startDate: A DATE expression.

• numMonths: An integral number.

Returns:
A DATE. If the result exceeds the number of days of the month the result is rounded down to the end of the month. If the result exceeds the supported range for a date an overflow error is reported.

Examples:

> SELECT add_months('2016-08-31', 1);
 2016-09-30
> SELECT add_months('2016-08-31', -6);
 2016-02-29 

See more:

• Spark
• Hive

Issue Links

• links to: GitHub Pull Request #20323