[datetime SELECT on DB] datetime questino

[Jascha Vincke]

hello,

> -----Ursprüngliche Nachricht-----
> Von: thomas gorbach [mailto:blackinch at t0.or.at]
> Gesendet: Mittwoch, 23. April 2003 11:37
> An: mysql-de at lists.4t2.com
> Betreff: Re: [datetime SELECT on DB] datetime questino
> 
> 
> Ben9000 wrote:
> 
> >-----BEGIN PGP SIGNED MESSAGE-----
> >Hash: SHA1
> >
> >Hello dear list,

> >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)?

> >Thx for ur help! 
> >Enjoy the day.
> >
> >Ben :)

> i did like this:
> select * from table where attribut  = "2003-04-23";
> 
> greetns
> TOM

i have had problems with this query, i did like this:

SELECT * FROM dttest WHERE dt LIKE '2003-04-23 %'

hth
Jascha

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