PERIOD_ADD

Declaration

PERIOD_ADD(P,N)

Description

Adds N months to the period P. The P parameter can be in the YYMM or YYYYMM format.

The return value is in the YYYYMM format.

info

The P parameter cannot be a DATE value.

Example

SELECT PERIOD_ADD(200801,2);
+----------------------+
| PERIOD_ADD(200801,2) |
+----------------------+
|               200803 |
+----------------------+
1 row in set (0.001 sec)