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

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent!! Date format change

Re: Urgent!! Date format change

From: Craig Kelley <ink_at_inconnu.isu.edu>
Date: 2000/04/07
Message-ID: <m1em8hk59a.fsf@inconnu.isu.edu>#1/1

"Mike Ng" <mike_at_email.tech-trans.com> writes:

> Hi all,
>
> I want to use the date format like this "DD-MM-YYYY HH24:MI:SS" but I need
> use the sql
> "alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS" to setup the
> environment every time I login.
>
> I have try to add the following format in init.ora file but it did not work.
> The string I add is NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS" Is there
> elsewhere I need to change? I want to change it permanently in server side.
> Or this parameter can only be changed in client side. Please give me some
> hints.

Contrary to the documentation which ships with Oracle, the NLS_DATE_FORMAT needs to be an environment variable (or in the registry, if you're running NT).

I have this in /etc/profile:

export NLS_DATE_FORMAT=DD-MON-YYYY

Unfortunately, you must do this for each Oracle client as well...

(unless I'm missing something)

-- 
The wheel is turning but the hamster is dead.
Craig Kelley  -- kellcrai_at_isu.edu
http://www.isu.edu/~kellcrai finger ink@inconnu.isu.edu for PGP block
Received on Fri Apr 07 2000 - 00:00:00 CDT

Original text of this message

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