PERIOD_DIFF
Syntax
PERIOD_DIFF(P1,P2)
Description
Returns the number of months between periods P1 and P2. P1 and P2
can be in the format YYMM
or YYYYMM
, and are not date values.
If P1 or P2 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.
Examples
SELECT PERIOD_DIFF(200802,200703); +----------------------------+ | PERIOD_DIFF(200802,200703) | +----------------------------+ | 11 | +----------------------------+ SELECT PERIOD_DIFF(6902,6803); +------------------------+ | PERIOD_DIFF(6902,6803) | +------------------------+ | 11 | +------------------------+ SELECT PERIOD_DIFF(7002,6803); +------------------------+ | PERIOD_DIFF(7002,6803) | +------------------------+ | -1177 | +------------------------+
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.