Oracle

Select sysdate from dual

DB2

Select current timestamp from sysibm.sysdummy1;

2.字符型转成timestamp

to_timestamp('2011-01-26 15:42:18','yyyy-mm-dd hh24:mi:ss.ff')

timestamp('2010-02-01 11:00:00')