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_at_serv2.vsi.ru>
Date: Fri, 14 Jun 2002 12:27:45 -0700
Message-ID: <aec9jg$18ui$1_at_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 - 21:27:45 CEST