[datetime SELECT on DB] datetime questino

[Ben9000]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello dear list,

I have a column of type datetime in my DB. This means a date AND the 
time r stored. 

I want to search only for a date "2003-04-23" how can I build SELECT 
query which finds all entries with the right date (and leaving out 
the time)?

Somehow I m stuck in this, well I guess its easy - as always - and 
simple - as always - but right now It seems I ve to SELECT all 
entries and filter the strings in PHP :(

Thx for ur help! 
Enjoy the day.

Ben :)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+pWcTROwluvOuI4ARAlfSAJ9hyD4q003bXpt1YNPfLsgQGQ/WDwCeIIFg
uq/fx9C46hEiuNSsJfvRq30=
=J3Qk
-----END PGP SIGNATURE-----


-- 
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql