db2与oracle差别

1.取得日期

Oracle

Select sysdate from dual

DB2

Select current timestamp from sysibm.sysdummy1;

2.字符型转成timestamp

ORACLE
to_timestamp('2011-01-26 15:42:18','yyyy-mm-dd hh24:mi:ss.ff')
DB2
timestamp('2010-02-01 11:00:00')