Oracle only uses the NLS_DATE_FORMAT when you don't give an explicit
format mask. In this case, you specified "mmyy", so the NLS_DATE_FORMAT
was ignored. Try using to_date('0199','mmrr') instead.
tedchyn_at_yahoo.com wrote:
>
> 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:34:10 CST
