DATETIME comparison?

[sosothirsty]

I have yesterday's date stored in a column. If I do a comparison >NOW() it comes up true. How do I correctly compate DATETIME fields to NOW()?

[bradgrafelman]

Can you show us some sample data and the SQL query you tried? Sounds like you've got something messed up, because the regular comparison operator works just fine in MySQL...

SELECT '2012-03-08' > NOW(); # Result: 0
SELECT '2012-03-09' > NOW(); # Result: 0
SELECT '2012-03-10' > NOW(); # Result: 1

[sosothirsty]

I see now, I can't do a count(mytime<now()). I want to do that as opposed to select count(*) where mytime<now()

[tomhath]

select SUM(case when mytime<now() then 1 else 0 end) as DaCount from...

[johanafm]

Why not use the WHERE clause to limit the selection. That's why it's there

SELECT count(*)
...
WHERE mytime<now()