Re: Urgent!! Date format change

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/07
Message-ID: <955112003.4438.0.pluto.d4ee154e@news.demon.nl>#1/1

This parameter needs to be set at the client side in the registry under HKLM\software\oracle

Hth,
Sybrand Bakker, Oracle DBA

"Mike Ng" <mike_at_email.tech-trans.com> wrote in message news:38ed9ced_2_at_news1.prserv.net...
> 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.
>
> Thanks a lot.
>
> Regards,
> Mike Ng
>
>
>
>
Received on Fri Apr 07 2000 - 00:00:00 CDT