C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
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. Syntaxselect period_add(period, number); 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 1Select period_add(201808,2); Output: Example 2Select period_add(201210,2); Output:
Next TopicMySQL datetime
|