|
how to use now() in a where clause mysqlI had a table which had a timestamp on it, I only wanted to return records
that were dated today, regardless of time, however it was date and time stamped so needed to
find a way to shorten the now() and my timestamp column
This is what i came up with:
select timestamp from table where
left(timestamp,10)=left(now(),10);
Worked a treat
|
|