ORACLE 10g:To

本文介绍了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.