Re: How do you change the date default?

You can also find (or create) the LOGIN.SQL file in your ORAWIN\BIN\ directory (or whatever directory SQL/PLUS uses as it's default) and add the following line to it:

alter session set nls_date_format='DD-MON-YYYY';

SQL/PLUS looks for this script and runs it automatically every time you start a session (I hate fiddling with the registry, and NLS_DATE_FORMAT is not in my Windows NT registry either). Regards,
Paul

In article <950711344.17073.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> If there is no entry for nls_date_format that is strange, in that
 case you
> need to make one. Add a string value nls_date_format and specify as
 value
> dd-mon-yyyy without quotes.
> 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.
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 17 2000 - 00:00:00 CET