I never saw the original post, but you'll want to use the TO_DAYS() function in your query.
SELECT TO_DAYS(leave_to) - TO_DAYS(leave_from) AS Num_Days FROM your_table ---John Holmes... ----- Original Message ----- From: "Lazor, Ed" <[EMAIL PROTECTED]> To: "'Jack'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 20, 2002 12:53 PM Subject: RE: [PHP] Date Comparsion > Check out the date() and mktime() functions. > > > -----Original Message----- > > Now i want to compare the leave_from and leave_to date to find out the > > number of days between! > > > > What should i do or any function in php can provide this operation? > > > **************************************************************************** > This message is intended for the sole use of the individual and entity to > whom it is addressed, and may contain information that is privileged, > confidential and exempt from disclosure under applicable law. If you are > not the intended addressee, nor authorized to receive for the intended > addressee, you are hereby notified that you may not use, copy, disclose or > distribute to anyone the message or any information contained in the > message. If you have received this message in error, please immediately > advise the sender by reply email and delete the message. Thank you very > much. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php