Re: Getting NLS_DATE_FORMAT to work with MM/DD/RR parameter

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Fri, 13 Nov 98 21:32:51 +0200
Message-ID: <ABZb8JsK42@protasov.kiev.ua>

Hi,

You do not need to change it in init.ora. Change it in client's registry using regedit under the key HKEY_LOCAL_MACHINE-> SOFTWARE->ORACLE. Andrew Protasov

> I would like to have the database either roll-up or roll-down the
> century on date columns. From what I have read, it appears that the
> NLS_DATE_FORMAT initialization parameters allows you to to this. I
> have modified the INITORCL.ORA file to include the following:
>
> NLS_DATE_FORMAT = "MM/DD/RR"
>
> I have tried several other combinations with no success. Anytime I
> insert a date, e.g, 11/13/02, I get 11/13/1902. What am I doing
> wrong? Any help would be greatly appreciated. Thanks in advance.
>
> Gerald M. Lewis
> Senior Systems Expert
> HAZMED, Inc.
>
>
Received on Fri Nov 13 1998 - 13:32:51 CST