RE: [Q] ORACLE date select problem?

From: Dennis Taylor <ismgr_at_pctc.com>
Date: Fri, 13 Oct 2000 09:01:08 -0700
Message-Id: <10648.119205@fatcity.com>

At 08:06 AM 10/13/00 -0800, you wrote:
>I tried this, still same.
>

Works for me:

SQL> create table datetest (thedate date);

Table created.

SQL> insert into datetest values (to_date('96/12/31','YY/MM/DD'));

1 row created.

SQL> insert into datetest values (to_date('92/05/01','YY/MM/DD'));

1 row created.

SQL> insert into datetest values (to_date('98/01/21','YY/MM/DD'));

1 row created.

SQL> commit;

Commit complete.

SQL> select * from datetest where thedate < to_date('31-DEC-96','DD-MON-YY');

THEDATE

---

01-MAY-92 SQL> select * from datetest where thedate >= to_date('31-DEC-96','DD-MON-YY');

THEDATE

---

31-DEC-96
21-JAN-98 SQL>

---
Dennis Taylor
---
Don't worry about people stealing your ideas.  If your ideas
are any good,
you'll have to ram them down people's throats.

Received on Fri Oct 13 2000 - 11:01:08 CDT