Re: A really strange problem
From: Jerason Banes <jbanes_at_techie.com>
Date: Thu, 13 Jun 2002 21:10:36 GMT
Message-ID: <gT7O8.6906$Zf2.544810132_at_newssvr13.news.prodigy.com>
Date: Thu, 13 Jun 2002 21:10:36 GMT
Message-ID: <gT7O8.6906$Zf2.544810132_at_newssvr13.news.prodigy.com>
Try:
select * from casetext 2 where createdate = '2002-6-13';
And if that doesn't work:
select * from casetext 2 where createdate = '2002-6-13 00:00.00';
Jerason Banes
-- ____________________________________ How to manage your database in one easy step! http://www.datadino.com "Ilya Shambat" <ishambat_at_aol.com> wrote in message news:d02408fc.0206131235.2cabf009_at_posting.google.com...Received on Thu Jun 13 2002 - 23:10:36 CEST
> 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?