Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> New NLS_DATE_FORMAT won't "stick"
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