Yes. You can do that when you are creating an instance, define the parameter
nls_date_format in the init.ora file as per your requirement, then the
nls_date_format for the Instance would be as supplied by you.
Alter Session/Alter System would do the same at the time so defined.
Vikas Khanna
-----Original Message-----
Sent: Tuesday, July 30, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L
Hi,
The default date format for an instance is dd-mon-yyyy.
Ex when issue the following statement "Select to_char(sysdate) from dual;"
The output is 01-Jan-2002.
I want to change this format to mm/dd/yyyy.
According to Oracle documentation this can be changed @ sesion level by the
following :
Alter session set nls_date_format='mm/dd/yyyy'; ( alter system does not
work).
To change it @ the instance level, the following needs to be added in the
init.ora file :
Nls_date_format="mm/dd/yyyy".
After starting the instance, when we check v$parameter, this change is
reflected. But the same is not reflected while selecting data. Again when
the sysdate select is issued the result does not change.
The date format was not specified while installing Oracle or creating the
instance, it was a default installation. Is there anyway to change this?
Other Info on Database :
Version Oracle 8.1.6
OS - Windows NT
NLS_TERRITORY - AMERICA
NLS_LANGUAGE - AMERICAN
Charset WE8ISO8851
Thanks in advance
Sunil Gompa
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sunil Kumar
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vikas Khanna
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
