Re: how to change nls date format.

Did you check the registry on the machine that you execute sqlplus on to see if there is nls_date_format there?

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, July 30, 2002 7:38 AM

> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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).