SQL•SQL References

MySQL DATEDIFF() Function

Example

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

Definition and Usage

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

Syntax

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

Loading lesson path

SQL•SQL References

Example

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

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

Syntax

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