datetime v mysql

[Petr Vanek]

On Mon, 06 May 2002 04:44:14 +0200
Tom Hudec <Tom na ABBA.cz> wrote:

> Tom Hudec wrote:
> > Tom Hudec wrote:
> > 
> >> Petr Vanek wrote:
> >> mysql> select id from articles where DATE_FORMAT(dt,'%Y-%m-%d') = 
> >> '2002-05-05';
> > 
> > 
> > Jeste me napadlo mozna cistsi reseni:
> > 
> > select id from articles where sdate between
> >  '2002-05-05' and '2002-05-05' + INTERVAL '23:59:59' HOUR_SECOND;
> 
> Uz mi to v tuto dobu nemysli, lepe samozrejme takto:
> 
> select id from articles where sdate between
>   '2002-05-05' and '2002-05-05 23:59:59';
> 
> Predchozi navrh se da pouzit v pripade, ze '2002-05-05' neni retezec.
> 
> 


wow, diky moc za quicklou odpoved!

p.s. ja mam pul dvanacte, ale copak vy tam o pul pate jeste nespite?
nebo uz? ;-)

-- 
bye

Vanous
-------------------------------------------------
Petr Vanek                       ..... ./\.  ....
Debian GNU Linux                 .. _|\|  |/|_ ..
vanous na penguin.cz                .. \        /...
http://www.penguin.cz/~vanous    ... >______< ...
Angus, Ontario, CA               ...... / .......
-------------------------------------------------
Registered linux user #217487
------------- další část ---------------
A non-text attachment was scrubbed...
Name: [žádný popis není k dispozici]
Type: application/pgp-signature
Size: 189 bytes
Desc: [žádný popis není k dispozici]
URL: <http://www.linux.cz/pipermail/databases/attachments/20020505/dae88324/attachment.sig>