Help: Change Default Date Format NLS_DATE_FORMAT
From: Tuyen Nguyen <Tuyen.Nguyen_at_PinpointSolutions.com>
Date: 28 Jul 1998 00:15:58 GMT
Message-ID: <01bdb9bd$14e79240$0d78828c_at_tuyen>
Hi Everyone,
Date: 28 Jul 1998 00:15:58 GMT
Message-ID: <01bdb9bd$14e79240$0d78828c_at_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, should it be True? If it should, then how do I change it?
Thanks in advance.
Tuyen Received on Tue Jul 28 1998 - 02:15:58 CEST