Re: a date question ?

Because you are using YY in your insert date mask, not RR.

Daniel
Austin, Texas

<tedchyn_at_yahoo.com> wrote in message news:85ibcp$7u5$1_at_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 - 11:41:43 CST