今天写存储过程的时候,遇到一期表和二期表几个字段是数据类型不一致而导致的错误。
下面是转换测试的结果:
---------------------------------------------------------------------------------------------
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')