Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> New NLS_DATE_FORMAT won't "stick"

New NLS_DATE_FORMAT won't "stick"

From: Frank Siegel <NorthernSnow_at_worldnet.att.net>
Date: Thu, 22 Jul 1999 11:13:05 -0400
Message-ID: <7n7cm2$s2$1@bgtnsc02.worldnet.att.net>


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 Received on Thu Jul 22 1999 - 10:13:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US