Cannot set NLS_DATE_FORMAT on OS/2

Any ideas for the same problem in OS/2?

On Sat, 20 Jun 1998 22:15:05, "David" <darussell_at_msn.com> wrote:

> If you want the init.ora parameters to take presedence over the registry
> then remove all nls_ parameters from the registry.
>
> Regards
> David Russell
>
> Louis wrote in message <358BBF73.65269D2A_at_cgi.ca>...
> >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 Thu Jul 02 1998 - 00:00:00 CDT