[PHP-DB] CURDATE

2010-08-16 Thread Ron Piggott 
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

Re: [PHP-DB] CURDATE

2010-08-16 Thread kesavan trichy rengarajan 
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.pigg...@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

Re: [PHP-DB] CURDATE

2010-08-16 Thread Aleksei Sapunov 
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 k...@trk7.com

 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.pigg...@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