Re: A really strange problem

From: Sergey M <msu_at_pronto.msk.ru>
Date: Fri, 14 Jun 2002 12:27:45 -0700
Message-ID: <aec9jg$18ui$1@serv2.vsi.ru>

Hello!

"Ilya Shambat" <ishambat_at_aol.com> wrote in message news:d02408fc.0206131235.2cabf009_at_posting.google.com...
> This is my SQL*Plus output
>
> SQL> select createdate from casetext
> 2 where textid like '44342%';
>
> CREATEDAT
> ---------
> 13-JUN-02
> 13-JUN-02
> 13-JUN-02
> 13-JUN-02
> 13-JUN-02
> 13-JUN-02
> 13-JUN-02
> 13-JUN-02
>
> 8 rows selected.
>
> SQL> select * from casetext
> 2 where createdate = '13-JUN-02';

Try this query: select * from casetext where trunc (createdate) = to_date ('13-JUN-02', 'dd-mon-rr');

Sergey M. Received on Fri Jun 14 2002 - 14:27:45 CDT