NEXT_DAY(’01-SEP-95′,1) 此SQL语句表示下周第一天(即下周日)
执行这条语句:select NEXT_DAY(’01-SEP-95′,1) from dual;
报错:ORA-01843:not a valid month
如何解决?
方案:修改注册表。
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_DevSuiteHome1下的NLS_LANG键值:将SIMPLIFIED CHINESE_CHINA.ZHS16GBK改为AMERICAN_AMERICA.ZHS16GBK,OK!
查看当前数据库的字符集:
SQL>select userenv(‘language’) from dual;
SQL>select userenv(‘lang’) from dual;