RE: New NLS_DATE_FORMAT won't "stick"

Hi Frank!

Yes! You're right! I have the same problem over an Oracle 7.3.2.1.0 in a SunOs 4.1.4

I puted the NLS_DATE_FORMAT=DD-MON-RR and also 'DD-MON-RR', but I receive, when I make the select to the NLS_SESSION_PARAMETERS, the value DD-MON-YY

For the Gurus.... Any idea about this?

Best regards and thanks in advance,

Italo Bozzi

vvvvvvv

Frank Siegel <NorthernSnow_at_worldnet.att.net> escribió en el mensaje de noticias 7n7cm2$s2$1_at_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 - 16:36:06 CDT