Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

PERIOD_ADD () and PERIOD_DIFF () in MariaDB

  • Last Updated : 12 Nov, 2020

1. PERIOD_ADD Function :

In MariaDB, The PERIOD_ADD () takes a period (formatted as YYMM or YYYYMM) and adds a specified number of months to it. In this function, the first parameter will be a period and the second parameter will be a number. This function will return the result formatted as YYYYMM.

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

Syntax :

PERIOD_ADD( period, number)

Parameter :



ParameterDescription
PeriodA period formatted as either YYMM or YYYYMM.
NumberA total number of months to add to the period. It can be negative or positive

Return :

It will return a period (formatted as YYMM or YYYYMM).

Example-1 :

SELECT PERIOD_ADD(202006, 6);

Output :

202012

Example-2 :

SELECT PERIOD_ADD(201902, -10);

Output :

201804

Example-3 :

SELECT PERIOD_ADD(1806, 5);

Output :



201811

2. PERIOD_DIFF Function :

In MariaDB, The PERIOD_DIFF () is used to return the difference in months between two periods (formatted as YYMM or YYYYMM). In this function, the first parameter will be a period1 and the second parameter will be the period2. The arguments  period1 and period2 must be formatted as either YYYYMM or YYMM, but to be the same format as each other. So period1 could be formatted as YYYYMM then period2 must be formatted as YYYYMM or vice versa.

Syntax :

PERIOD_DIFF( period1, period2 )

Parameters :

ParametersDescription
Period1The first period in which the month of period2 will be subtracted.
Period2The second period will be subtracted from period 1.

Return :

Returns the difference in months between two periods 

Example-1 :

SELECT PERIOD_DIFF(202005, 202002);

Output :

3

Example-2 :

SELECT PERIOD_DIFF(1908, 1901);

Output :

7

Example-3 :

SELECT PERIOD_DIFF(201903, 201909);

Output :

6
My Personal Notes arrow_drop_up
Recommended Articles
Page :