Re: [PHP-DB] Re: Diff between 2 date

2006-10-10 Thread Christian Flothmann
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

Re: [PHP-DB] Re: Diff between 2 date

2006-10-05 Thread Skip Evans
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

Re: [PHP-DB] Re: Diff between 2 date

2006-10-05 Thread Nandar
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

[PHP-DB] Re: Diff between 2 date

2006-10-05 Thread Roby -
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.