Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NLS_DATE_FORMAT
I've had this same problem. The solution is to add the NLS_DATE_FORMAT
string to the registry. The key(s) to add this string value to are:
//HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMEx
* where "x" is a number 0 - #number of Oracle homes you have - 1
jst <jsp_at_pobox.sk> wrote in message
news:950000332.718461_at_virtual.nextra.sk...
> How can I change NLS_DATE_FORMAT from "DD-mmm-YY" to e.g. "DD.MM.YYYY"? I
> want to insert SYSDATE into a table and see through the SELECT command in
> other format than default. I tried to set NLS_DATE_FORMAT = "DD.MM.YYYY"
in
> init.ora file, or ALTER SESSION SET NLS_DATE_FORMAT = "DD.MM.YYYY" and
> restart, but it does`nt work. I`m using Oracle 8.0.5 on Win NT.
>
> Thanks, Jan
>
>
>
>
Received on Wed Feb 09 2000 - 16:13:17 CST