ORA-01846:not a valid day of the week .
来源:互联网 发布:mac 开发者必备软件 编辑:程序博客网 时间:2024/05/29 07:17
转载于:http://blog.csdn.net/dreamingcoder259/article/details/6091737
执行语句
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
- sed 编辑文本文件
- 在mac os X下安装gnuplot的步骤和方法
- 访问MFC动态连接库
- zoj 1949 Error Correction
- C++表达式和语句
- ORA-01846:not a valid day of the week .
- 创建MFC动态连接库
- (小结)pass-by-reference-to-const替换pass-by-value
- rails-手册
- linux重定向及nohup不输出的方法
- 给你的程序在Win7上加个小盾,设置manifest
- 基于用户管理的备份与恢复—恢复重做日志
- Busybox简介及使用
- 给力!简单!易懂!位运算之求集合的所有子集