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

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 Received on Mon Aug 11 1997 - 00:00:00 CDT