Re: A really strange problem
From: andy <andreshof_at_hotmail.com>
Date: Sun, 16 Jun 2002 20:31:53 +0000
Message-ID: <3D0CF5B9.7000808_at_hotmail.com>
Date: Sun, 16 Jun 2002 20:31:53 +0000
Message-ID: <3D0CF5B9.7000808_at_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 - 22:31:53 CEST