nls_date_format参数设置.docxVIP

nls_date_format参数设置的问题收藏今天在练习TO_DATE()和TO_CHAR()函数的时候发现了一个问题,就是说nls_date_format参数在会话级alter session修改起作用,可在系统级alter system却不起作用.具体情况如下:view plaincopy to clipboardprint?01.SQL select sysdate from dual; 02. 03.SYSDATE 04.--------------- 05.19-OCT-09 06.SQL alter session set nls_date_format=MON-DD-YYYY; 07. 08.Session altered. 09.SQL select sysdate from dual; 10. 11.SYSDATE 12.----------------- 13.OCT-19-2009 14. 15.SQL 16.======================================================== 17.SQL alter system set nls_date_format=MON-DD-YYYY scope=spfile; 18. 19.System altered