Re: [PHP-DB] CURDATE()

2011-08-19 Thread who.cat
I tried on my db "select count(*) from my_table where col_timestamp wrote: > On Thursday, August 18, 2011, Ron Piggott wrote; > > > What I tried below doesn t work: ( CURDATE() . % ) > > Even though date values are presented like strings, they are > dates/times. So you need to either cast CURDATE

Re: [PHP-DB] CURDATE()

2011-08-18 Thread Geoff Lane
On Thursday, August 18, 2011, Ron Piggott wrote; > What I tried below doesn’t work: ( CURDATE() . % ) Even though date values are presented like strings, they are dates/times. So you need to either cast CURDATE() to a string or else perform 'date arithmetic'. Check the manual for DATEDIFF(), CAS

[PHP-DB] CURDATE()

2011-08-18 Thread Ron Piggott
I am setting up a daily cron job to update the site map on my web site. I want to delete any records that weren’t updated by the cron job each day. The way I can distinguish this is with the timestamp column named “last_record_update” If a record wasn’t updated it is no longer part of the

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

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" wrote: I am wondering why: SELECT * FROM `bible_concordance_usage`

[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