Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent!! Date format change
"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 blockReceived on Fri Apr 07 2000 - 00:00:00 CDT