MySQL DATEDIFF() function

MySQL DATEDIFF() function

MySQL Date function

Definitions and usages

The DATEDIFF() function returns the number of days between the two dates.

Grammar

The date1 and date2 parameters are legitimate date or date/time expressions.

Note: Only the date portion of the value participates in the calculation.

Instance

Here's the SELECT statement:

The result is as follows:

Instance

Here's the SELECT statement:

The result is as follows:

MySQL Date function