SQL> select sysdate from dual;SYSDATE ---------- 30-8月 -02SQL> create table a (d date);表已创建。SQL> insert into a values (TO_DATE('2002-AUG-22','YYYY-MON-DD')); insert into a values (TO_DATE('2002-AUG-22','YYYY-MON-DD')) * ERROR 位于第 1 行: ORA-01843: 无效的月份 SQL> insert into a values (TO_DATE('2002-8月-22','YYYY-MON-DD'));已创建 1 行。SQL> ALTER SESSION SET NLS_LANGuage=AMERICAN 2 ;Session altered.SQL> select sysdate from dual;SYSDATE --------- 30-AUG-02SQL> insert into a values (TO_DATE('2002-AUG-22','YYYY-MON-DD'));1 row created.SQL> commit;Commit complete.SQL> select * from a;D --------- 22-AUG-02 22-AUG-02SQL>
----------
30-8月 -02SQL> create table a (d date);表已创建。SQL> insert into a values (TO_DATE('2002-AUG-22','YYYY-MON-DD'));
insert into a values (TO_DATE('2002-AUG-22','YYYY-MON-DD'))
*
ERROR 位于第 1 行:
ORA-01843: 无效的月份
SQL> insert into a values (TO_DATE('2002-8月-22','YYYY-MON-DD'));已创建 1 行。SQL> ALTER SESSION SET NLS_LANGuage=AMERICAN
2 ;Session altered.SQL> select sysdate from dual;SYSDATE
---------
30-AUG-02SQL> insert into a values (TO_DATE('2002-AUG-22','YYYY-MON-DD'));1 row created.SQL> commit;Commit complete.SQL> select * from a;D
---------
22-AUG-02
22-AUG-02SQL>