Javatpoint Logo
Javatpoint Logo

MySQL Date/Time period_add() Function

The period_add() is a MySQL date/time function. This function adds the given number of month in the given period in the formate YYMM or YYYYMM.

Syntax

Parameter:

Period : period value in formate YYMM or YYYYMM

Number: number of months to be added in period.

Returns:

This function returns the result formatted as YYYYMM.

Example 1

Output:


MySQL Datetime period_add() Function

Example 2

Output:


MySQL Datetime period_add() Function
Next TopicMySQL datetime




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA