ORA-01846:not a valid day of the week
来源:互联网 发布:war thunder mac 编辑:程序博客网 时间:2024/06/08 19:10
执行语句
select next_day('2010-12-11', 'TUESDAY') from dual
报错 ORA-01846:not a valid day of the week
解决办法:
alter session set nls_date_language = 'American'
alter session 只对当前会话生效;
alter system ......scope=spfile 修改spfile,重启后生效;
alter system ......scope=memory修改当前的实例,不修改spfile,重启后失效;
alter system ......scope=both(默认) 当前实例生效且修改spfile。
nls_date_language , SERVER端的日期类型的lang,比如中文的时候,显示“星期一”,英文时,显示MONDAY。官方解释:NLS_DATE_LANGUAGE specifies the language to use for the spelling of day and month names
and date abbreviations (a.m., p.m., AD, BC) returned by the TO_DATE and TO_CHAR functions.NLS_LANGUAGE specifies the default language of the database. This language is used for messages,
day and month names, symbols for AD, BC, a.m., and p.m., and the default sorting mechanism.
This parameter also determines the default values of the parameters NLS_DATE_LANGUAGE and NLS_SORT.
- ORA-01846: not a valid day of the week
- ORA-01846:not a valid day of the week
- ORA-01846:not a valid day of the week .
- Ora-01846: not a valid day of the week(转)
- 关于ORACLE ORA-01846: not a valid day of the week 错误的解决办法
- Support for specifying both a day-of-week AND a day-of-month parameter is not implemented
- a day、 a week
- Day of Week
- OJ_1043 Day of Week
- Day of Week
- Day of Week
- ORA-01843: not a valid month
- ORA-01843: not a valid month
- ORA-01843: not a valid month 错误
- ORA-01843: not a valid month
- the environment variable java_home (with the value of ) does not point to a valid jvm installation
- jobdu 7 Day of Week
- 题目7:Day of Week
- jquery插件制作
- 验证控件与Button的OnClientClick事件(转)
- Symbian 创建、删除文件夹
- SVN的trunk branch tag
- java时间格式大全
- ORA-01846:not a valid day of the week
- PDF抽词报错:java.lang.NullPointerException at org.pdfbox.pdmodel.PDPageNode.getAllKids(PDPageNode.java:194)
- linux下遍历目录树方法总结(上)
- vb+access求助题目
- Symbian崩溃保留解决方案
- oracle 视图
- struts 2 2.1和ajax
- fread没有读完整个文件
- How to setup Apache + Python + Django + mod_wsgi