Re: nls_date_format

"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 Mon Jul 23 2001 - 13:13:21 CDT