how do you query on a TIMESTAMP column to return all records of date today?
I've been using "where date = 20010418 AND date 20010419" syntax
and changing the dates as necessary, but I'd like to replace this
with some kind of today() function.
Andrew
Andrew Warner wrote:
how do you query on a TIMESTAMP column to return all records of date today?
I've been using "where date = 20010418 AND date 20010419" syntax
and changing the dates as necessary, but I'd like to replace this
with some kind of today() function.
Andrew
Use now()