PERIOD_ADD
Syntax
PERIOD_ADD(P,N)
Description
Adds N
months to period P
. P
is in the format YYMM or YYYYMM, and is not a date value. If P
contains a two-digit year, values from 00 to 69 are converted to from 2000 to 2069, while values from 70 are converted to 1970 upwards.
Returns a value in the format YYYYMM.
Examples
SELECT PERIOD_ADD(200801,2); +----------------------+ | PERIOD_ADD(200801,2) | +----------------------+ | 200803 | +----------------------+ SELECT PERIOD_ADD(6910,2); +--------------------+ | PERIOD_ADD(6910,2) | +--------------------+ | 206912 | +--------------------+ SELECT PERIOD_ADD(7010,2); +--------------------+ | PERIOD_ADD(7010,2) | +--------------------+ | 197012 | +--------------------+
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.