Re: New NLS_DATE_FORMAT won't "stick"

On Thu, 22 Jul 1999 11:13:05 -0400, "Frank Siegel" <NorthernSnow_at_worldnet.att.net> wrote:

>Thank you in advance for any light you may shed on this mystery.
>
>I cannot get the nls_date_format of DD-MON-RR to stick!
>Is there a UNIX (digital alpha) parameter that is overiding init.ora?
>
>Here are my init.ora parameters:
>
>nls_date_format=DD-MON-RR
>fixed_date=05-JAN-00
>
>I also tried:
>nls_date_format='DD-MON-RR'
>nls_date_format="DD-MON-RR"
>
>
>Here are my session paramters:
>SQL> select * from nls_session_parameters;
> NLS_LANGUAGE AMERICAN
>NLS_TERRITORY AMERICA
>NLS_CURRENCY $
>NLS_ISO_CURRENCY AMERICA
>NLS_NUMERIC_CHARACTERS .,
>NLS_DATE_FORMAT DD-MON-YY
>NLS_DATE_LANGUAGE AMERICAN
>NLS_SORT BINARY
>NLS_CALENDAR GREGORIAN
>
>
>Here are my database parameters
>SQL> select * from nls_database_parameters;
>NLS_LANGUAGE AMERICAN
>NLS_TERRITORY AMERICA
>NLS_CURRENCY $
>NLS_ISO_CURRENCY AMERICA
>NLS_NUMERIC_CHARACTERS .,
>NLS_DATE_FORMAT DD-MON-YY <-- here, you see!!!!
>NLS_DATE_LANGUAGE AMERICAN
>NLS_CHARACTERSET US7ASCII
>NLS_SORT BINARY
>NLS_CALENDAR GREGORIAN
>NLS_RDBMS_VERSION 7.3.3.0.0
>
>
>Thanks again!
>Frank S.
>new Hampshire
>
>
>
>

Hi Frank,
You need to set the environment variable NLS_DATE_FORMAT. Otherwise the client software is using the default setting, which is DD-MON-YY.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Jul 22 1999 - 12:21:39 CDT