the problem is DATEDIFF command available in MySQL ver 4.1.1 above
In MySQL versions < 4.1.1 you can use the following construct:
SELECT TO_DAYS('2006-10-06') - TO_DAYS('2006-10-05')
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
sage -
> From: "Roby -" <[EMAIL PROTECTED]>
> To:
> Sent: Friday, October 06, 2006 10:44 AM
> Subject: [PHP-DB] Re: Diff between 2 date
>
>
> > Using SQL statement: datediff, example:
> > SELECT
the problem is DATEDIFF command available in MySQL ver 4.1.1 above
- Original Message -
From: "Roby -" <[EMAIL PROTECTED]>
To:
Sent: Friday, October 06, 2006 10:44 AM
Subject: [PHP-DB] Re: Diff between 2 date
> Using SQL statement: datediff, example:
> SELECT date
Using SQL statement: datediff, example:
SELECT datediff( day, '2006-10-05', '2006-10-06' )
Hope it helps you ;-)
-
All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.