Re: Cannot set NLS_DATE_FORMAT

In my initsid.ora I've tried:

nls_date_format = 'DD-MON-RR'

but oracle still assumes 'DD-MON-YY' as the default date mask.

(I'm trying to get year-2000-compliance.)

I'm using 7.3.2.3 on sun/solaris2.5

Can you help?

Cheers,
Steve

Jonathan Gennick wrote:

> On Sat, 20 Jun 1998 23:15:05 +0100, "David"
> <darussell_at_msn.com> wrote:
>
> >If you want the init.ora parameters to take presedence over the
> registry
> >then remove all nls_ parameters from the registry.
>
> Wow! This certainly clears up a mystery for me. I too, could
> never get that NLS_DATE_PARAM setting to "stick" on my
> Windows PC. Why would you ever not want the INIT.ORA params
> to take precedence? Why would Oracle even confuse the issue
> by using the registry instead of the INIT file? It's just
> one more difference between platforms that we have to worry
> about.
>
> regards,
>
> Jonathan
Received on Wed Jun 24 1998 - 01:31:59 CDT