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
On Thursday, August 18, 2011, Ron Piggott wrote;
> What I tried below doesnt 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
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
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
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`
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
