Querying a date

[erickwidya]

what do mean it wasn't happy?

try this one

select * from table where date_column = #1-11-2004#

PS : don't forget to format the date to appropriate format