修改客户端日期格式，总是忘记。

alter session set nls_date_language='american';

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as herbert SQL> alter session set nls_date_language='american'; Session altered SQL> select to_date('01-NOV-13','yyyy-mm-dd') newdate   from dual; NEWDATE-----------0001-11-13SQL> select to_date('01-NOV-13','dd-mm-yyyy') newdate   from dual; NEWDATE-----------0013-11-1 SQL> select to_date('01-NOV-13','rrrr-mm-dd') newdate   from dual; NEWDATE-----------2001-11-13 SQL>