Declaration
PERIOD_ADD(P,N)
Description
Add N months to the time period P, where P is in the format YYMM or YYYYMM.
The return value is in the format of YYYYMM.
Note
The P parameter cannot be of the DATE type, that is, it must not be a date value.
Examples
obclient> SELECT PERIOD_ADD(200801,2);
+----------------------+
| PERIOD_ADD(200801,2) |
+----------------------+
| 200803 |
+----------------------+
1 row in set