Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can Oracle 7.x store 4-digit year dates?
Erwan Layman wrote:
>
> Marc Scheuner wrote:
>
> 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
You can globally change the default date format using NLS_DATE_FORMAT in your init.ora file.
Marc