Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: nls_date_format
Hai
NT system has a small catch .Though you may change in the init.ora
file it will not do the change . You have to do it in NT REGISTRY. Change nt
registry NLS_DATE_FORMAT=dd/mon/YYYY
If it does not exit create a new nls_Date_Format key in the registry .
vinod
vinod_km_at_yahoo.com
tmurphy_at_pinnsoft.com wrote in message <6n0nq6$ip7$1_at_nnrp1.dejanews.com>...
>When I set my unix init.ora to:
> nls_date_format = "DD MON RRRR"
>then restart the instance, the svrmgr "show parameters nls"
>shows the new format.
>also, when I start SQLplus and do a "select * from v$nls_parameters",
>my new format is active in my session and all is well.
>
>When I do the same on NT, the "show parameters nls" shows
>the new format, but the sessions end up with the standard "DD-MON-YY"
>format. If I explictly "alter session set nls_date_format = 'DD MON
RRRR'",
>then that session is OK, but the instance wide default is
>still "DD-MON-YY".
>
>Any clues on why Oracle acts differently on NT than Unix?
>
>Thanks!
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Jun 26 1998 - 16:53:44 CDT