Re: CURDATE
| From: | kesavan trichy rengarajan | Date: | Mon, 16 Aug 2010 20:57:33 +0000 |
| Subject: | Re: CURDATE | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47309@lists.php.net to get a copy of this message | ||
Try:
DATE(date_accessed) = CURDATE().
Have a look at this:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_dateto
understand what's happening.
Regards,
Kesavan.
On 17/08/2010 6:26 AM, "Ron Piggott" <ron.piggott@actsministries.org> wrote:
I am wondering why:
SELECT * FROM
bible_concordance_usage WHERE date_accessed = CURDATE()
Doesn't work when date_accessed is column type "timestamp"
And
What would work?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php