Re: [PHP-DB] CURDATE
[email protected] (kesavan trichy rengarajan)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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" <[email protected]> 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