Error starting at line 1 in command:
SELECT TO_DATE('02-AUG-2003') - TO_DATE('31-JUL-2003') FROM dual
Error report:
SQL Error: ORA-01843: not a valid month
01843. 00000 - "not a valid month"
*Cause:
*Action:
SELECT TO_DATE('02-AUG-2003') - TO_DATE('31-JUL-2003') FROM dual
Error report:
SQL Error: ORA-01843: not a valid month
01843. 00000 - "not a valid month"
*Cause:
*Action:
可以执行啊.返回结果是2.
SELECT TO_DATE('02-AUG-2003'),TO_DATE('31-JUL-2003') FROM dual
这样返回
TO_DATE('02-AUG-2003') TO_DATE('31-JUL-2003')
1 2003-8-2 2003-7-31你的错误:
SQL Error: ORA-01843: not a valid month
01843. 00000 - "not a valid month"
是不是你的数据库不支持这种英文月份缩写?看看你的系统区域或者NLS_LANG我的也是10G,NLS_LANG=AMERICAN_AMERICA.ZHS16GBK