Re: New NLS_DATE_FORMAT won't "stick"

        If you use Windows client set NLS_DATE_FORMAT='DD-MON-RR' in the registry. In unix you can use
 
        alter session set nls... in the glogin.sql file.
 

Regards
stephen

Italo Bozzi wrote:

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@worldnet.att.net> escribió en el mensaje de
noticias 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
>
>
>
>