MySQL Date/Time period_diff() FunctionThe period_diff() is a MySQL date/time function. It is used to get the difference between two given periods. SyntaxParameter:period1 : period value in formate YYMM or YYYYMM. period2 : period value in formate YYMM or YYYYMM. Returns:This function returns the difference in months between two periods. Example 1Output: Example 2Output:
Next TopicMySQL datetime
|