SELECT
TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-RR'), 'DD-MON-YYYY')
FROM dual
执行不了,解决方法:
1.select * from v$nls_parameters ,查看NLS_LANGUAGE,NLS_DATE_LANGUAGE。
默认为SIMPLIFIED CHINESE,将其设置为american即可,
3种操作如下:
(1)alter system set NLS_DATE_LANGUAGE = American
(2)alter session set NLS_DATE_LANGUAGE = American[只改变session范围)
(3)在系统中添加环境变量:NLS_LANG=AMERICAN_AMERICA.ZHS16GBK