MySQL DATEDIFF() Function

Return the number of days between two date values:

SELECT DATEDIFF("2017-06-25", "2017-06-15");

Definition and Usage

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

DATEDIFF( date1, date2)

Parameter	Description
date1, date2	Required. Two dates to calculate the number of days between. (date1 - date2)

Works in:	From MySQL 4.0

Return the number of days between two date values:

SELECT DATEDIFF("2017-06-25 09:34:21", "2017-06-15 15:25:35");

Return the number of days between two date values:

SELECT DATEDIFF("2017-01-01", "2016-12-24");