Re: CURDATE()

["who.cat" <win.acc@xxxxxxxxx>]

I tried on my db
"select count(*) from my_table where col_timestamp<curdate();"
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 <geoff@xxxxxxxxxxxxx> 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
>
>