the problem is DATEDIFF command available in MySQL ver 4.1.1 above ----- Original Message ----- From: "Roby -" <chien_ye@xxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Friday, October 06, 2006 10:44 AM Subject: Re: Diff between 2 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. > ---------------------------------------------------------------------------- ---- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.407 / Virus Database: 268.13.0/464 - Release Date: 10/5/2006 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
