I tried on my db
select count(*) from my_table where col_timestampcurdate();
the column col_timestamp type is timestamp,this sql works well.
hope it helpful.
All you best
What we are struggling for ?
The life or the life ?
On Thu, Aug 18, 2011 at 5:21 PM, Geoff Lane ge...@gjctech.co.uk 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() to a string or else
perform 'date arithmetic'. Check the manual for DATEDIFF(), CAST(),
and CONVERT().
NOT LIKE ( CURDATE() . % )
I suspect that PHP's concatenation operator (the period) isn't
recognised by MySQL (assuming that's the DB you're using). So you need
to either use MySQL's CONCAT() function or else create the search
string in PHP rather than MySQL. However, if you're going to do this,
you need to also cast last_record_update to a string.
Personally, I'd use:
WHERE DATEDIFF(CURDATE(), last_record_update) 1
(testing for 1 rather than 0 just in case the date rolled over between
the update and the 'stale record' check.)
HTH,
--
Geoff
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php