Re: Help: Change Default Date Format NLS_DATE_FORMAT

For each oracle session that is opened you will need to set the nls_date_format to 'DD-MON-RR' as the oracle session does not read the instance setting. use ALTER SESSION SET NLS_DATE_FORMAT ... In forms you will also have to set the format mask for each date field correctly.

Tuyen Nguyen wrote in message <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 Aug 04 1998 - 01:36:24 CEST