Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot set NLS_DATE_FORMAT

Re: Cannot set NLS_DATE_FORMAT

From: Louis <louis.contant_at_cgi.ca>
Date: 1998/06/20
Message-ID: <358BBF73.65269D2A@cgi.ca>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US