Mike Blezien wrote:
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
Mike,
DAYOFYEAR works only well if both dates are in the same year.
SELECT DAYOFYEAR('2006-01-01') - DAYOFYEAR('2005-12-31');
results in a negative number.
Jorrit
--
System Developer
Infopact Network Solutions
Hoogvlietsekerkweg 170
3194 AM Rotterdam Hoogvliet
tel. +31 (0)88 - 4636700
fax. +31 (0)88 - 4636799
mob. +31 (0)6 - 14105968
[EMAIL PROTECTED]
http://www.infopact.nl/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]