ORA-01846错误是Oracle数据库中的一个常见错误,其错误消息为“not a valid day of the week”(不是有效的周中的日)。下面是对该错误的详细解释、可能的原因以及解决方法的建议。 1. ORA-01846错误的含义 ORA-01846错误通常发生在处理日期函数时,尤其是当使用到需要指定星期几的函数(如NEXT_DAY)时。如果提供的...
NEXT_DAY(ADD_MONTHS(hire_date, 6),'Sunday') REVIEW FROM hr.employees; 运行返回错误: (二)错误分析 (1)查看错误号: [oracle@localhost ~]$ oerr ora 01846 01846, 00000, "not a valid day of the week" // *Cause: // *Action: (2)在server端sqlplus上运行 SQL> SELECT last_name,hire_date...
not a valid day of the week Cause A date specified an invalid day of the week. Valid days are: Monday-Sunday, for format code DAY Mon-Sun, for format code DY 1-7, for format code D Action Enter a valid day of the week value in the correct format....
关于ORACLE ORA-01846: not a valid day of the week 错误的解决办法 - yusiyu的技术专栏 - 博客频道 - CSDN.NET http://t.cn/R6W1ktT
ORA-01846: not a valid day of the week Cause:A date specified an invalid day of the week. Valid days are Monday-Sunday, for format code DAY Mon-Sun, for format code DY 1-7, for format code D Action:Enter a valid day of the week value in the correct format. ...
ORA-01843:not a valid month OceanBase 错误码:5641 SQLSTATE:HY000 错误原因:不是有效的月份。 ORA-01846:not a valid day of the week OceanBase 错误码:5642 SQLSTATE:HY000 错误原因:不是有效的星期的数值。 ORA-01847:day of month must be between 1 and last day of month ...
day()是语言相关的，所以我怀疑你的数据库不是英文的。您可以通过以下查询检查数据库的语言：...
ORA-01846: not a valid day of the week Cause: A date specified an invalid day of the week. Valid days are: - Monday-Sunday, for format code DAY - Mon-Sun, for format code DY - 1-7, for format code D Action: Enter a valid day of the week value in the correct format. OR...
ORA-01846: not a valid day of the week ORA-01847: day of month must be between 1 and last day of month ORA-01848: day of year must be between 1 and 365 (366 for leap year) ORA-01849: hour must be between 1 and 12 ORA-01850: hour must be between 0 and 23 ORA-01851...
ORA-01846: not a valid day of the week Cause: A date specified an invalid day of the week. Valid days are: - Monday-Sunday, for format code DAY - Mon-Sun, for format code DY - 1-7, for format code D Action: Enter a valid day of the week value in the correct format. OR...