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

Hi Gerald,

Probably you are not setting the NLS_DATE_FORMAT on your clients, as init parameter does not count, only NLS_DATE_FORMAT settings on the client machines count.

Look and try the following :--

On NT client machines as well as NT Server machine, you have to use NLS_DATE_FORMAT in registry.

Here is how you do it:-

1. Start->Run->regedit32 <OK>
2. HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE. Highlight/Select ORACLE
3. Menu->Edit->Add Value..

3.1 Add Value Window

    Value Name : NLS_DATE_FORMAT
    Data Type : REG_EXPAND_SZ ( Choose this from list.)

                   <OK>

3.2  String Editor Window
         String  : DD-MON-YYYY
		   <OK>

In Oracle on WINDOWS NT the registry key NLS_DATE_FORMAT works and initialization parameter NLS_DATE_FORMAT has no effect.

Inference from Research : NLS_DATE_FORMAT Initialization Parameter has no effect on the default date format on Oracle on NT platform.

Similraly for Windows NT clients you need to set NLS_DATE_FORMAT inside oracle.ini file.

hope this helps,

Manoj Jain
Chauncey Certified Oracle7 DBA
Oracle Certified Professional DBA

In article <364C6458.5B19B7AB_at_us.oracle.com>,   Diego Pafumi <dpafumi_at_us.oracle.com> wrote:
> I think you are doing good. But first i need to know how is the format
> where you storage that value, that format must be 'rr' too.
>
> Gerald M. Lewis wrote:
>
> > 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.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 13 1998 - 16:42:07 CST