Re: Client side NLS_DATE_FORMAT, how do I set?

from a previous discussion, I get the following answer from Neil Boemio

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.

In article <350aa879.160906571_at_news.alpha.net>, bsteele_at_hillbilly.com (Biff Steel) wrote:
>We have changed the NLS_DATE_FORMAT on our server and all works fine
>when we login from the server. When W95 or NT clients startup up
>windows tools, like SQLPLUS, the NLS_DATE_FORMAT reverts to the
>standard/default DD-MON-YY.
>
>I know I need to set something on the clients but not sure the best
>way to do this.
>
>Please help
>john moran jmoran_at_baraboo.com

Nicolas

Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member

The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Sun Mar 15 1998 - 00:00:00 CET