MySQL PERIOD_ADD() function; In this tutorial, i am going to show youMySQL period_add() function with the help of examples.

The PERIOD_ADD() function adds a specified number of months to a period. The PERIOD_ADD() function will return the result formatted as YYYYMM.

### Syntax of MySQL PERIOD_ADD() Function

The syntax of the MySQL PERIOD_ADD() function is below:

`PERIOD_ADD(Period,Num)`

Here: Period is the period, and Num is the number of months to add.

### Example 1 – MySQL PERIOD_ADD() Function

Let’s take a simple example of this function; as follows:

`SELECT PERIOD_ADD(201901,2);`

#### Output-1

```+----------------------+
+----------------------+
|               201904 |
+----------------------+
```

### Example 2 – MySQL PERIOD_ADD() Function

Lets’s take an second example that adds a negative number of months in given period; as follows:

`SELECT PERIOD_ADD(202101,-2);`

Output-2

```+-----------------------+
+-----------------------+
|                201904 |
+-----------------------+
```

This example uses the component of the only two-digit year. Here first two number is a year and second to number is a month, after common that the number of periods adds to the given period.

`SELECT PERIOD_ADD(1901,2);`

#### Output-3

```+--------------------+
+--------------------+
|             201903 |
+--------------------+
```

Here, you will notice that the given result by this query is a year in four digits.

### Example 4 – MySQL PERIOD_ADD() with CURDATE Function

This example derives the period from the current date. It then adds a month on to that period.

```    SELECT
CURDATE( ) AS 'Current Date',
EXTRACT(YEAR_MONTH FROM CURDATE( )) AS 'Current Period',
PERIOD_ADD(EXTRACT(YEAR_MONTH FROM CURDATE( )), 1) AS 'Next Period';
```

#### Output-4

```+--------------+----------------+-------------+
| Current Date | Current Period | Next Period |
+--------------+----------------+-------------+
| 2019-07-21   |         201907 |      201908 |
+--------------+----------------+-------------+
```

## Conclusion

MySQL PERIOD_ADD() Function tutorial, you have learned how to use MySQL PERIOD_ADD() function with various examples.