Notice: session_start(): A session had already been started - ignoring in /home/u614325693/domains/onedoubt.com/public_html/post.php on line 3
PERIOD_DIFF - ONEDOUBT.COM

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