MySQL DATEDIFF() Function
 MySQL Date Functions
Definition and Usage
The DATEDIFF() function returns the time between two dates.
Syntax
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('2008-11-30','2008-11-29') AS DiffDate |
will result in this:
Example
The following SELECT statement:
| SELECT DATEDIFF('2008-11-29','2008-11-30') AS DiffDate |
will result in this:
MySQL Date Functions
Click here to design a Stunning Flash Website for Free
Wix is a revolutionary web design tool that provides anyone with the possibility to create professional and beautiful websites for free.
With e-commerce features, search engine visibility and many more professional tools, Wix is the ultimate solution for creating a spectacular site while saving tons of money.
| 
