MONTHS_ADD

Description

The MONTHS_ADD function is used to add or subtract a specified number of months to a given date and returns the resulting date.

Syntax

MONTHS_ADD(<datetime/date>, <nums>)

Parameters

Parameter	Description
<datetime/date>	The date value to which months will be added or subtracted
<nums>	The number of months to add or subtract

Return Value

The return value is of the same type as the input <datetime/date>. Special cases:

• If the <datetime/date> input is 0000-00-00 or 0000-00-00 00:00:00, the function returns NULL.
• If the <datetime/date> input is NULL, the function returns NULL.
• If the input is MONTHS_ADD("9999-12-31", 1), the function will return NULL.

Example

select months_add("2020-01-31 02:02:02", 1),months_add("2020-01-31", 1),months_add("2020-01-31", -1);

+-------------------------------------------------------------+---------------------------------------------+----------------------------------------------+
| months_add(cast('2020-01-31 02:02:02' as DATETIMEV2(0)), 1) | months_add(cast('2020-01-31' as DATEV2), 1) | months_add(cast('2020-01-31' as DATEV2), -1) |
+-------------------------------------------------------------+---------------------------------------------+----------------------------------------------+
| 2020-02-29 02:02:02                                         | 2020-02-29                                  | 2019-12-31                                   |
+-------------------------------------------------------------+---------------------------------------------+----------------------------------------------+