LOGIN
Saturday, December 14, 2024
Top Posts
SUBSCRIBE NEWSLETTERS
Home » MySQL period_add() Function
MySQL Date/Time FunctionsMysql Tutorial

MySQL period_add() Function

by Online Tutorials Library

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

You may also like

MySQL String OCTET_LENGTH() Function

MySQL String POSITION() Function

MySQL String LEFT() Function

MySQL String LENGTH() Function

MySQL String MID() Function

MySQL String LCASE() Function