Your database does not start from init.ora file after certain version. Any change you do there is purely for your own enjoyment. On 03/11/2004 09:00:03 AM, David Boyd wrote: > Hi List, > > I set nls_date_format="YYYY-MM-DD HH24:MI:SS" in the init file. However, > > if I select * from nls_database_parameters . . . nls_date_format = > DD-MON-RR > if I select * from nls_instance_parameters . . . nls_date_format = > YYYY-MM-DD HH24:MI:SS > > How??? > > _________________________________________________________________ > One-click access to Hotmail from any Web page ? download MSN Toolbar now! > http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/ > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------