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@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...


> 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:36 CDT