本文介绍了ORACLE 10g:To_date()无效月份的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
所以我有这个小脚本:
set serveroutput on; DECLARE val DATE; BEGIN val := TO_DATE('27-Jan-2001','DD-Mon-YYYY'); dbms_output.put_line(val); END;掩码与我输入的日期匹配,但显示
The mask match with the date I'm inputing but it displays
ORA-01843:无效的月份
ORA-01843: not a valid month
每次...
谢谢
推荐答案您当前的会话NLS_DATE_LANGUAGE最有可能被设置为1月不缩写为"Jan"的值.
Most likely your current session NLS_DATE_LANGUAGE is set to a value where January is not abbreviated as "Jan".
尝试一下:
DECLARE val DATE; BEGIN val := TO_DATE('27-Jan-2001','DD-Mon-YYYY', 'NLS_DATE_LANGUAGE = american'); dbms_output.put_line(val); END;或执行
ALTER SESSION SET NLS_DATE_LANGUAGE = 'american';在运行PL/SQL块之前.
before you run your PL/SQL block.
更多推荐
ORACLE 10g:To
发布评论