nls_date_format confusion

From: DNA <dna1_at_dnabbott.freeserve.co.uk>
Date: Mon, 5 Jul 1999 20:57:00 +0100
Message-ID: <7lr2mc$h9m$1@news6.svr.pol.co.uk>

Hi All,
I am getting confused about the nls_date_format parameter. I set it to 'DD-MON-YYYY' in the parameter file but when I look at the various nls views I get the following for this parameter :

nls_session_parameters : DD-MON-YY
nls_instance_parameters : DD-MON-YYYY
nls_database_parameters : DD-MON-YY

v$parameter : DD-MON-YYYY
I can understand the instance and parameter views but surely the session parameters should pick up the value when it connects to the database? Or am I missing something?
The database is 7.3.4 on NT4.

Thanks! Received on Mon Jul 05 1999 - 14:57:00 CDT