Re: Cannot set NLS_DATE_FORMAT

Hello Leon,

You have to edit the Win95 registry and set this value in the appropriate entry, the one labelled 'nls_date_format'.

1. Start menu -> execute
2. Type in 'regedit'
3. Open the branch Local Machine -> Software -> Oracle
4. On the rigth panel find the entry and edit.

Regards, Louis.

Leon Caruana wrote:

> I am using Personal Oracle 7 and would like to change the default date
> format to dd-mm-yyyy. I have amended the INTIORCL.ORA initialization file in
> \orawin95\bin to include the following line;
>
> nls_date_format = "dd-mm-yyyy"
>
> This is accepted as i checked it with the show parameters option. However,
> in any applicationaccessing the database such as SQLPlus, the date is still
> shown as dd-mon-yy unless I issue the alter session command and change the
> nls_date_format again.
>
> Does anyone have an idea as to what is happening and how it can be
> rectified? Thank you very much.
>
> Leon Caruana
Received on Sat Jun 20 1998 - 00:00:00 CDT