Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: nls_date_format

Re: nls_date_format

From: Hieraklion <hieraklion_at_spray.fr>
Date: Tue, 24 Apr 2001 17:50:20 +0200
Message-ID: <3AE5A0BC.770EC028@spray.fr>

"Bonjour" from Paris,

You can change this parameter in

a/ Instance : Add NLS_DATE_FORMAT in the instance init.ora

b/All sessions of a user : Add in the user environnement NLS_DATE_FORMAT (registry for NT, export NLS_DATE_FORMAT for unix). Achtung : you have to add the NLS_LANG variable too (same thing that NLS_DATE_FORMAT relative to your OS) in you choos this method. If not, the NLS_DATE_FORMAT will not be taken into account.

c/Session : Use alter session set at the svrmgrl, sqlplus, worksheet prompt.

Do not forget, c/ has priority on b/ if you put the value using several methods.

                      b/ has priority on a/
                      c/ has priority on a/

"Au revoir" from Paris
Hieraklion

Wayne Pascoe a écrit :

> Hi all,
>
> Is there any way to change the default oracle nsl_date_format after
> I've created a database? I am having to issue
>
> alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS';
>
> at the beginning of each of my sessions. Is there a way to make this
> the default, or do I have to recreate the database?
>
> Thanks,
>
> --
> - Wayne Pascoe
> E-mail: wayne.pascoe_at_realtime.co.uk
> Phone : +44 (0) 20 7544 4668
> Mobile: +44 (0) 788 431 1675
Received on Tue Apr 24 2001 - 10:50:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US