Re: Re: Diff between 2 date

From: Date: Tue, 10 Oct 2006 07:49:02 +0000
Subject: Re: Re: Diff between 2 date
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-42520@lists.php.net to get a copy of this message
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')

« previous php.db (#42520) next »