NOW () not working properly

Nicholas1127 · May 25, 2011, 6:08pm

Hello,

I’m calling up database entries using this string:

select * from table WHERE date>=NOW() ORDER BY date ASC

The problem… it’s pulling all records > than NOW, not including today. Why would this happen?

Thanks.

Nick

lothop · May 26, 2011, 1:09am

Because it is checking the time aswell, not just the date. so NOW() is > any thing recorded today.
I could be wrong

smokeys_13 · May 26, 2011, 12:24pm

Hi there,

Try putting:

date>=DATE(NOW()) ORDER BY