classic (My?)SQL mistake

Dunno about other databases.

SELECT * FROM my_table WHERE date > '2009-11-17'



But what you intend to do is actually
SELECT * FROM my_table WHERE `date` > '2009-11-17'

Of course. If you have an editor with SQL highlighting this would probably not happen.