months_add

description

Syntax

DATETIME MONTHS_ADD(DATETIME date, INT months)

Add the specified month from the date

The parameter date can be DATETIME or DATE, and the return type is consistent with that of the parameter date.

example

  1. mysql> select months_add("2020-01-31 02:02:02", 1);
  2. +--------------------------------------+
  3. | months_add('2020-01-31 02:02:02', 1) |
  4. +--------------------------------------+
  5. | 2020-02-29 02:02:02                  |
  6. +--------------------------------------+

keywords

  1. MONTHS_ADD