unable to change nl_date_format(NT oracle)

From: <tedchyn_at_yahoo.com>
Date: Sat, 10 Apr 1999 04:20:26 GMT
Message-ID: <7emji6$pvr$1@nnrp1.dejanews.com>

Sir,

After add nls_date_format=DD-MON-YYYY to init.ora file and restart oracle, the nls_database_parameters still show DD-MON-YY format( alert.log indicate the right nls_date_format).

However, I'm able to use alter session command to change nls_date_format to DD-MON-YYYY(but this only last for a session).

nls_lang is the right format. I'm using oracle 8.0.5(NT).

Thanks in advance

Ted Chyn (please respond to tedchyn_at_yahoo.com)

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 09 1999 - 23:20:26 CDT