原帖由 kjh2004yjn 于 2008-1-22 22:15 发表
今天写了如下代码,本以为没有问题,但是问题最终还是出现了
SQL> SELECT NEXT_DAY(DATE '2008-08-01', 'FRIDAY')
2FROM dual;
SELECT NEXT_DAY(DATE '2008-08-01', 'FRIDAY')
FROM dual
ORA-01846: not a valid day of the week
请问各位,这错在哪里呢?谢谢!
22:43:10 SQL> select next_day(to_date('2008-08-1','yyyy-mm-dd'),'星期五') "next day" from dual;
next day
-------------------
2008-08-08,00:00:00
|