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_at_netnews.upenn.edu>
Date: 13 Jun 2002 21:10:48 GMT
Message-ID: <aeb1oo$6c0$1_at_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 - 23:10:48 CEST