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

From: John Blackburn <jdblack_at_qdot.qld.gov.au>
Date: 1997/08/12
Message-ID: <33F0B121.19AB@qdot.qld.gov.au>#1/1

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