Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How/where do I put NLS_DATE_FORMAT in W95 Registry
NLS_DATE_FORMAT="MM/DD/YYYY" -- or whatever date format you need
2) Also, this parameter needs to be changed from the registry:
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:
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_at_baraboo.com
--
\\|// \\\|/// (0-0) ( o o ) +===oOO===(_)===========================oooO==(_)==Oooo=======+ | | | Neil Boemio | | nboemio_at_bway.net | | http://www.bway.net/~nboemio/ ooo0 | | ( ) Oooo. | +================oOO=====================\ (====( )=========+ |__|__| \_) ) / || || (_/ ooO OooReceived on Tue May 05 1998 - 22:10:34 CDT