NLS_DATE_FORMAT problem

From: Stefan Jahnke <sjahnke_at_tkc.de>
Date: Tue, 19 Jan 1999 21:33:31 +0100
Message-ID: <36A4EC1B.E7D3AA6B@tkc.de>

Hi,

my database instance is set to German and the date format is ´dd.mm.yy´. Now I want to change the date format to ´dd.mm.yyyy´. This works fine with ALTER SESSION SET NLS_DATE_FORMAT = ´dd.mm.yyyy´ for one session. I want to set this parameter for the whole instance and therefor put it in the init.ora file with NLS_DATE_FORMAT = ´dd.mm.yyyy´. Unfortunately, after restarting the instance, the NLS_DATE_FORMAT setting in NLS_DATABASE_PARAMETERS is still ´dd.mm.yy´. Doesn´t this work for the whole instance ? If not, how can I do it then ? Is there any other way to set a date format that´s valid for the whole instance ?

TIA
Stefan
LUW Software GmbH

---

Powered by Linux and Mozilla
For further Information check out
www.linux.org and www.mozilla.org

Received on Tue Jan 19 1999 - 14:33:31 CST