MySQL Date/Time period_add() FunctionThe 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. SyntaxParameter: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 1Output: ![]() Example 2Output: ![]()
Next TopicMySQL datetime
|