向Oracle插入timestamp类型字段

 如果是中文字符集：

[TEST@ora10gr1#2009-11-25/08:39:38]

SQL>create table t1(t timestamp);

Table created.

[TEST@ora10gr1#2009-11-25/08:39:56]

SQL>insert into t1 values(to_timestamp('21NOV09 10:04:12.032','DDMONYY HH24:MI:SS.FF'));

* ERROR at line 1: ORA-01843: not a valid month

应该指定用american字符集插入就对了：

[TEST@ora10gr1#2009-11-25/08:39:56]

SQL>insert into t1 values(to_timestamp('21NOV09 10:04:12.032','DDMONYY HH24:MI:SS.FF','nls_date_language=american'));

1 row created.