note 53587 added to ref.datetime

For those who are using pre MYSQL 4.1.1, you can use: TO_DAYS([Date Value 1])-TO_DAYS([Date Value 2]) For the same result as: DATEDIFF([Date Value 1],[Date Value 2]) ---- Manual Page -- http://www.php.net/manual/en/ref.datetime.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+53587 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+53587&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+53587&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+53587&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+53587&report=yes&reason=useless Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+53587&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+53587&report=yes Search -- http://master.php.net/manage/user-notes.php