Re: NLS_DATE_FORMAT problem

Be sure that NO NLS_ parameters are set on the Client workstation...If ANY are set, all others will be set to Oracle's defalt settings....regardless of initsid.ora or any other setting...

Hope it helps,

Stefan Jahnke <sjahnke_at_tkc.de> wrote:

>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

To reply please remove the 'nospam' part of the address Received on Tue Jan 19 1999 - 15:22:18 CST