Re: NLS_DATE_FORMAT Oracle 9i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 25 Jan 2002 19:36:31 +0100
Message-ID: <3d935u405ftql91fjn1qt6q297lviuj8v6@4ax.com>

On 25 Jan 2002 05:02:02 -0800, steve.davis_at_nps-aurora.com (Steve Davis) wrote:

>Setting the nls_date_format tag in the init<<DBNAME>>.ora does not
>seem to set the value in the nls_session_parameters table. Any one
>know why?
>
>We have proved that its reading the right 'init' file, and that its
>parsing the tag but just not setting the value.
>
>We are able to 'alter session' but not 'alter system' so new sessions
>get the old value.
>
>We are running on NT4 SP6.
>
>All help appreciated.
>
>Cheers, Steve

Please read

http://osi.oracle.com/~tkyte/Misc/NLSDateFormat.html

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jan 25 2002 - 12:36:31 CST