nls_date_format

From: <tmurphy_at_pinnsoft.com>
Date: Fri, 26 Jun 1998 18:03:51 GMT
Message-ID: <6n0nq6$ip7$1@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 - 13:03:51 CDT