Help: Change Default Date Format NLS_DATE

From: Tuyen Nguyen <Tuyen.Nguyen_at_PinpointSolutions.com>
Date: 27 Jul 1998 23:06:32 GMT
Message-ID: <01bdb9b3$7a806000$0d78828c@tuyen>

Hi Everyone,

I have Oracle7.1.x.x installed on an NT3.51 machine. I added NLS_DATE_FORMAT = 'DD-MON-RR' to the initorcl.ora and NT's registry.
I restarted the computer and Oracle.
When I inserted a record with date = '21-Jun-07' using SQL*plus, I got back 21-Jun-1907 instead of 21-Jun-2007.

What did I do wrong? Does anyone know why?

When I checked V$PARAMETER, I got nls_date_format = 'DD-MON-RR' . However, the ISDEFAULT = FALSE, does it should be True? If it is, then how do I change it?

Thanks in advance.

Tuyen Received on Mon Jul 27 1998 - 18:06:32 CDT

Help: Change Default Date Format NLS_DATE_FORMAT