Q: a date question ?

From: <tedchyn_at_yahoo.com>
Date: Wed, 12 Jan 2000 16:50:41 GMT
Message-ID: <85ibcp$7u5$1@nnrp1.deja.com>

Sir: I have following date question:

SQL> alter session set nls_date_format='dd-mon-rrrr';

Session altered.

SQL> insert into x_1 values(to_date('0199','mmyy'));

1 row created.

SQL> select * from x_1;

C1

---

01-jan-2099

Is there a way I am able to get 01-jan-1999 instead of 01-jan-2099 ? looks like rrrr did not work.
thanks in advance
ted chyn

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 12 2000 - 10:50:41 CST