Oracle日期处理

date类型只能精确到秒
timestamp能精确到毫秒
查询到毫秒(9i以上版本)

SQL>select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss:ff') from dual;

SQL>select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss:ssxff') from dual;

两段日期相差豪秒数

SQL>select ceil((to_date('1986-05-01 00:00:00','yyyy-mm-dd hh24:mi:ss')-to_date('2009-09-09 23:59:59','yyyy-mm-dd hh24:mi:ss'))*24*60*60*1000) from dual;