ORA-01846: not a valid day of the week

ORACLE 中用next_day取下周中的某一天时,会遇到ORA-01846的错误

 

SQL> select next_day(sysdate,'TUESDAY') "NEXT_DAY" FROM DUAL;

select next_day(sysdate,'TUESDAY') "NEXT_DAY" FROM DUAL

ORA-01846: not a valid day of the week

SQL>
SQL> Select NEXT_DAY(sysdate,'星期一')  "NEXT_DAY" From dual
  2  UNION ALL
  3  Select NEXT_DAY(sysdate,2) "NEXT_DAY" From dual;

NEXT_DAY
-----------
2010-12-20
2010-12-20

 

洋鬼子认为一周的第一天是周日,所以要得到下个星期一要传入2  .   NEXT_DAY(sysdate,2)

 

 

官方文档中对NEXT_DAY的解释:

 

NEXT_DAY returns the date of the first weekday named by char that is later than the date date. The return type is always DATE, regardless of the datatype of date. The argument char must be a day of the week in the date language of your session,either the full name or the abbreviation. The minimum number of letters required is the number of letters in the abbreviated version. Any characters immediately following the valid abbreviation are ignored. The return value has the same hours, minutes, and seconds component as the argument date.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值