Jorrit,
----- Original Message -----
From: "Jorrit Kronjee" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Saturday, April 01, 2006 7:46 AM
Subject: Re: Getting number days between 2 dates
Mike Blezien wrote:
Hello,
I'm sure this is a simple query but haven't come up with a good approach.
Need to get the number of days between two dates. IE: today's date:
(2006-04-01 - 2006-03-05)
need to calculate the number of days between these dates.. what is the best
query statement to accomplish this?
TIA,
Mike,
You probably want to use something like this:
SELECT TO_DAYS('2006-03-15') - TO_DAYS('2006-03-01');
Thanks, that works, also using the DAYOFYEAR produces the same results as I just
found :)
appreciate the help
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
