Re: A really strange problem

From: andy <andreshof_at_hotmail.com>
Date: Sun, 16 Jun 2002 20:31:53 +0000
Message-ID: <3D0CF5B9.7000808@hotmail.com>

Ilya Shambat wrote:
> 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';
>
> no rows selected
>
>
> How can this be?

try this:

select *
from casetext
where trunc(createdate) = '13-JUN-02'; Received on Sun Jun 16 2002 - 15:31:53 CDT