[datetime SELECT on DB] datetime questino

[thomas gorbach]

Ben9000 wrote:

>-----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-----
>
>
i did like this:
select * from table where attribut  = "2003-04-23";

greetns
TOM


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