Hi all, I have a big question - why on this list raised question about MySQL or any other database without any relation to PHP? Is it list for solving SQL and DB problems? When I subscribe to this list I think that this list is about PHP DB problems. At least problems related to PHP - but not about problems about MySQL or any other db or their functions ... whats wrong? 2010/8/16 kesavan trichy rengarajan <k7@xxxxxxxx> > 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@xxxxxxxxxxxxxxxxxx> > 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 >
