Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: nls_date_format
For SQLPLUS client put this in your login.sql file (OK for V7 and V8):
alter session set nls_date_format='YYYY-MM-DD';
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message news:
995912003.18071.0.pluto.d4ee154e_at_news.demon.nl...
>
> "kane zhang" <kanezhang_at_hotmail.com> wrote in message
> news:5FO67.1300$Ma.33441_at_newscontent-01.sprint.ca...
> > Hi all:
> >
> > I had an oracle 7 client before. It's default date format is
'YYYY-MM-DD'.
> > After that, I installed oracle 8i personal edition and the date format
has
> > changed to 'DD-MON-YY' for version 7 application. I changed the win
registry
> > for oracle 7 home environment varable nls_date_format to
'YYYY-MM-DD',but
it
> > didnt' work. Can anyone tell me what happened and how I can used old
format
> > as default for version 7 appl.
> >
> > thanks.
> >
> > kane
> >
> >
>
> As you probably have multiple homes in hklm\software\oracle, are you sure
> you changed the *correct* variable, in the *correct* branch?
> Or did you install 8i in the same home as Oracle 7?
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Sat Jul 28 2001 - 17:45:12 CDT