how to change nls date format.

From: Sunil Kumar <sunil.gompa_at_patni.com>
Date: Mon, 29 Jul 2002 21:38:18 -0800
Message-ID: <F001.004A56F3.20020729213818@fatcity.com>

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: sunil.gompa_at_patni.com

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: ListGuru_at_fatcity.com (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). Received on Tue Jul 30 2002 - 00:38:18 CDT