Xref: alice comp.databases.oracle.misc:15068
Path: alice!news-feed.fnsi.net!newsfeed.wli.net!feed.nntp.acc.ca!newsin.agis.net!agis!kiki.bway.net!not-for-mail
From: Neil Boemio <nboemio@bway.net>
Newsgroups: comp.databases.oracle.misc
Subject: Re: How/where do I put NLS_DATE_FORMAT in W95 Registry
Date: Tue, 05 May 1998 23:10:34 -0400
Organization: Bway.net
Lines: 90
Message-ID: <354FD4AA.85F8629E@bway.net>
References: <354df99b.771294312@news.alpha.net>
Reply-To: nboemio@bway.net
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.05 [en] (Win95; I)
To: Biff Steel <bsteele@hillbilly.com>

1) The NLS_DATE_FORMAT parameter needs to be added to database
initialization
file (for example, initorcl.ora for default instance ORCL):

       NLS_DATE_FORMAT="MM/DD/YYYY"  -- or whatever date format you need

2) Also, this parameter needs to be changed from the registry:

   - run regedt32

   - select HKEY_LOCAL_MACHINE
         Software
             ORACLE

   - select 'Edit' from menu
   - select 'Add Value...' from submenu

        Value Name = NLS_DATE_FORMAT
        Data Type = REG_EXPAND_SZ or REG_SZ
        String = MM/DD/YYYY (or whatever date format that you need -- no
                             quotes are necessary)

3) To change NLS_DATE_FORMAT for a 16-bit application on the server, the
value
must be entered in the server's ORACLE.INI:

       NLS_DATE_FORMAT=MM/DD/YYYY

4) You must then stop the database and services, and restart.

5) NLS_DATE_FORMAT needs to be set on any client which has NLS_LANG set
(for
example, all Windows, Windows NT, Windows 95, and OS/2 clients), because
there
is a default NLS_DATE_FORMAT implied for any NLS_LANG.

For 16-bit client applications on Windows, Windows NT, and Windows 95,
the
parameter needs to be set in ORACLE.INI.  For 32-bit applications on
Windows
95, the parameter needs to be set in the registry:

   - run regedit.exe

   - select HKEY_LOCAL_MACHINE
         Software
             ORACLE

   - select 'Edit' from menu
   - select 'New' from submenu
   - select 'String Value' from submenu

        Value Name = NLS_DATE_FORMAT
              Data = MM/DD/YYYY (or whatever date format that you need --

no
                             quotes are necessary)

For 32-bit applications on Windows NT clients, the parameter is set as in

step 2, above.

********************************

Biff Steel wrote:

> Someone posted this info before by one of my two thumbs misplaced it.
> Just need to know where in the registry the NLS_DATE_FORMAT goes.
>
> Thanks a bunch.
> Don't reply to above address.
> nospam e-mail jmoran@baraboo.com



--
         \\|//                              \\\|///
         (0-0)                              ( o o )
+===oOO===(_)===========================oooO==(_)==Oooo=======+
|                                                             |
| Neil Boemio                                                 |
| nboemio@bway.net                                            |
| http://www.bway.net/~nboemio/         ooo0                  |
|                                       (   )   Oooo.         |
+================oOO=====================\ (====(   )=========+
        |__|__|                           \_)    ) /
         || ||                                  (_/
        ooO Ooo