Example

Return the difference between two periods:

SELECT PERIOD_DIFF(201710, 201703);

Definition and Usage

The PERIOD_DIFF() function returns the difference between two periods. The result will be in months.

Note: period1 and period2 should be in the same format.

Syntax

PERIOD_DIFF(period1, period2)

Parameter Values

Parameter Description
period1 Required. A period. Format: YYMM or YYYYMM
period2 Required. Another period. Format: YYMM or YYYYMM

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Return the difference between two periods:

SELECT PERIOD_DIFF(201703, 201803);

Example

Return the difference between two periods:

SELECT PERIOD_DIFF(1703, 1612);


Login
ADS CODE