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
|