ORACLE 10g:To_date()无效月份 [英] ORACLE 10g : To_date() Not a valid month

问题描述

所以我有这个小脚本:

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_date()无效月份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！