SQL> select to_date('2005-sep-20','yyyy-mon-dd') from dual;ORA-01843: 无效的月份SQL> alter session set NLS_DATE_LANGUAGE = American;Session alteredSQL> select to_date('2005-sep-20','yyyy-mon-dd') from dual;TO_DATE('2005-SEP-20','YYYY-MO ------------------------------ 2005-9-20
把设置模式改过来好了.
那应该如何做才可以使形如“15-sep-2005”的日期型数据插入到数据库中呢?
SQL> select to_date('2005-sep-20','yyyy-mon-dd') from dual;ORA-01843: 无效的月份SQL> alter session set NLS_DATE_LANGUAGE = American;Session alteredSQL> select to_date('2005-sep-20','yyyy-mon-dd') from dual;TO_DATE('2005-SEP-20','YYYY-MO
------------------------------
2005-9-20