Hi, Maybe I'm missing something but I tried solution someone posted for someone else's problem concerning finding out # of days between 2 dates.
I have 2 sets of dates I'm working with in my sample DB. order_date completion_date 2002-07-03 2002-07-09 and 2002-06-27 2002-07-08 Now the query I'm using is the following: select (completion_date-order_date) as days_elapsed from received where completion_date != 0; I get the following as a result: 6 81 Obviously there isn't 81 days between June 27th and July 8th. Can anyone tell me why mysql does the calculation this way and if there is a more correct way of doing the subtraction of the dates? Thanks Brandon --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
