VARCHAR2转换TIMESTAMP

今天写存储过程的时候，遇到一期表和二期表几个字段是数据类型不一致而导致的错误。

下面是转换测试的结果：

---------------------------------------------------------------------------------------------

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for 32-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

SQL> select  sysdate from dual;

SYSDATE
--------------
06-1月 -13

 

SQL> select to_timestamp('2013-01-06 12:00:00.1','yyyy-mm-dd hh24:mi:ss.ff') as aa from dual;

AA
---------------------------------------------------------------------------
06-1月 -13 12.00.00.100000000 下午

 

SQL> select to_timestamp_tz('2013-01-06 12:00:00.1','yyyy-mm-dd hh24:mi:ss.ff')