RE: Setting nls_date_format

Another bit of information:

If I look at NLS_INSTANCE_PARAMETERS, I see 'SYYYY-MM-DD HH24:MI:SS', the value that I expected.

• Peter Schauss

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Friday, May 04, 2007 1:20 PM
To: oracle-l_at_freelists.org
Subject: Setting nls_date_format

I am running Oracle 10.2.0.2.0 on HPUX B.11.23.

We have an application which complains that it is getting the date in 'DD-MON-RR' format.

I changed nls_date_format for the database using:

alter system set nls_date_format = 'SYYYY-MM-DD HH24:MI:SS' scope= spfile;

and restarted the instance to make the new value effective.

When I issue a "select sysdate from dual;" in sqlplus, I get the expected date format. I created a pfile and find the expected value there:

*.nls_date_format='SYYYY-MM-DD HH24:MI:SS'

When I look at the nls_database_parameter view, however, I see

PARAMETER                      VALUE


------------------------------ ----------------------------------------

NLS_DATE_FORMAT                DD-MON-RR

What is going on here and how can I set the "permanent" value for NLS_DATE_FORMAT? Thanks,
Peter Schauss
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 04 2007 - 14:46:24 CDT