Re: A really strange problem

From: Maurice Samuels <samuels_at_blue.seas.upenn.edu>
Date: 13 Jun 2002 21:10:48 GMT
Message-ID: <aeb1oo$6c0$1@netnews.upenn.edu>

try using
select * from casetext where trunc(createdate) = '13-JUN-02';

the trunc will set the hours:minutes:seconds to 00:00:00.

Ilya Shambat (ishambat_at_aol.com) 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?
Received on Thu Jun 13 2002 - 16:10:48 CDT