where-statement for a date column

[SoftIl]

Hi,
how is the rigth syntax for a where-statement for an date column?

I tried this:

select * from myTable where dateCol like '\A04.10.2004'

but it dosen't work. I get no records return.

If I select the records without the where-statement I get all records return.
In the column "dateCol" are this values for example:

04.10.2004 00:00:00
15.05.2004 00:00:00

Thanks for your help,
Carsten