MySQL in a Nutshell, 2nd Edition

Name

DATEDIFF()

Synopsis

DATEDIFF(date, date)

This function returns the number of days of difference between the two dates given. Although a parameter may be given in date and time format, only the dates are used for determining the difference. This function is available as of version 4.1.1 of MySQL. Here is an example:

SELECT CURDATE( ) AS Today,
DATEDIFF('2008-12-25', NOW( ))
AS 'Days to Christmas';

+------------+-------------------+
| Today      | Days to Christmas |
+------------+-------------------+
| 2008-03-14 |               286 |
+------------+-------------------+