Re: How do you change the date default?

[Quoted] If there is no entry for nls_date_format that is strange, in that case you [Quoted] need to make one. Add a string value nls_date_format and specify as value dd-mon-yyyy without quotes.
[Quoted] It is select to_char(sysdate) from dual;

Hth,

Sybrand Bakker, Oracle DBA

sc <cfs3526_at_hotmail.com> wrote in message news:950709056.174071_at_newsreader-hpw1.net.bms.com...
> I am using Oracle 7.3 personal edition on windows 98. My default format
 for
> date is
> 'DD-MON-YY'. I want to change it to 'DD-MON-YYYY'.
> I tried to change it in registry, but there is no entry for
 nls_date_format
> under local machine/
> software/oracle.
> I typed 'alter session set ......', I got a message saying the session has
> been changed, but when I select sysdate, I still got the same format as
> 'DD-MON-YY'.
>
> Is there anyway I can change the default?
>
> Thanks for your help.
>
>
Received on Wed Feb 16 2000 - 00:00:00 CET