today?

[kaits]

how to output all entries from DATETIME which are saved today?

 

[melmager]

i belive you mean a sql query

select * from tab where to_days(thedatefield) = to_days(now())

 

[kaits]

that doesn't work

I tried also this:
SELECT * FROM table WHERE DATE(field)=TODAY()

but that didn't worked too