Tutorial Gateway

MySQL PERIOD_ADD Function

by

MySQL PERIOD_ADD function is a Date Function, which is used to add the number of months to a given period. This function returns the output as YYYYMM format.

In this article, we will show you, How to use this MySQL Period add function to add the required months to given period with an example.

MySQL PERIOD_ADD Syntax

The basic syntax of the PERIOD_ADD() Function in MySQL is as shown below:

PERIOD_ADD(Period, Number_of_Months);

MySQL PERIOD_ADD function Example

This MySQL Period add function accepts either the YYYYMM or YYMM format value as the period argument.

The following examples helps you understand the use of this MySQL Period_add function. Here, we are add 3, 4, 6 months to specified period year 2019 and Month 01 and 06.

SELECT PERIOD_ADD(201901, 3);

SELECT PERIOD_ADD(201906, 4);

SELECT PERIOD_ADD(201906, 6);

OUTPUT

MySQL PERIOD_ADD Function 1

Let us see another example of the MySQL Period add function. Here, we are using the Period as YYMM format. Here, 95 means 1995, and 19 means 2019

SELECT PERIOD_ADD(9504, 6);

SELECT PERIOD_ADD(1905, 6);

SELECT PERIOD_ADD(1905, 11);

OUTPUT

MySQL PERIOD_ADD Function 2

Thank You for Visiting Our Blog