Re: Can Oracle 7.x store 4-digit year dates?

If you are working on a win95 computer then you may try to change the registry settings by
going into local machine,software,oracle and add a new string value by the name NLS_DATE_FORMAT whose value
should be "MM/DD/RRRR".After this you will not need to do alter session everytime.
Happy working
Ravi Alluru
Ravi_at_fifthd.ca

John Blackburn <jdblack_at_qdot.qld.gov.au> wrote in article <33F0B121.19AB_at_qdot.qld.gov.au>...
> Erwan Layman wrote:
> >
> > Marc Scheuner wrote:
> >
> > > Oracle always stores dates internally as numerical values, if you
 only
> > >
> > > see two digits for the year, that's simply a setting of preference
 for
> > >
> > > your session.
> > >
> > > Check out the ALTER SESSION SET NLS_DATE_FORMAT command. You can set
> > > any kind of date display you would like to have with it.
> >
> > Hello,
> >
> > Your suggestion to use ALTER SESSION works great. But I lose this
> > setting when I logout of SQL*Plus. How do I make this new date format
> > setting persistent for myself and for all users of my database? I have
> > DBA privilege. Thanks in advance.
> >
> > Erwan Layman
>
> put the setting in $ORACLE_HOME/sqlplus/admin/glogin.sql
>
Received on Tue Aug 12 1997 - 00:00:00 CDT