THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL DATEDIFF() Function


❮ MySQL Date Functions

Definition and Usage

The DATEDIFF() function returns the time between two dates.

Syntax

DATEDIFF(date1,date2)

Where date1 and date2 are valid date or date/time expressions.

Note: Only the date parts of the values are used in the calculation.


Example

The following SELECT statement:

SELECT DATEDIFF('2014-11-30','2014-11-29') AS DiffDate

will result in this:

DiffDate
1

Example

The following SELECT statement:

SELECT DATEDIFF('2014-11-29','2014-11-30') AS DiffDate

will result in this:

DiffDate
-1

❮ MySQL Date Functions