ORACLE9i处理毫秒级时间

---参考文档
--------D:/desktop/B10501_01/server.920/a96540/sql_elements4a.htm#34512
select systimestamp from dual;
select current_timestamp from dual;
select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff3') from dual;
select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff') from dual;
select to_char(systimestamp,'ff6') from dual
select to_timestamp('2003-10-24 10:48:45.633243333','yyyy-mm-dd hh24:mi:ss.ff') from dual;

叶正盛

2005-09-09