NLS_DATE_FORMAT not working on PC

From: <mbraund_at_my-deja.com>
Date: 2000/01/06
Message-ID: <851qu7$i16$1@nnrp1.deja.com>#1/1

I have an Oracle V7 database with nls_date_format parameter set to 'DD- -RR'.

When accessing the database through the Solaris SQL*Plus application this behaves as expected :

01-DEC-99 is stored as 01-DEC-1999
01-JAN-00 is stored as 01-JAN-2000

When accessing the same database with the same userid through the PC SQL*Plus client through SQL Net I get the following :

01-DEC-99 is stored as 01-DEC-2099
01-JAN-00 is stored as 01-JAN-2000

Selecting from nls_session_parameters reveals NLS_DATE_FORMAT = 'DD-MON- YY' while selecting from nls_instance_parameters reveals NLS_DATE_FORMAT = 'DD-MON-RR' Doing an explicit ALTER SESSION to set the nls_date_format yields the correct results.

Why is the PC access not working by default ? Is the database parameter being overridden ?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 00:00:00 CST