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)