| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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 <erwan_at_contact.com.sg> 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.
If you use the 16-bit Oracle client, there's a file called ORACLE.INI somewhere that has a section called [Oracle], and there you can set the date format permanently:
[Oracle]
NLS_DATE_FORMAT=DD.MM.YYYY
If you're using the 32-bit client, see David Martin's reply for
setting the registry key responsible for the date format.
HTH
Marc
 |
 |