Oracle获取年月日时分秒毫秒微秒

毫秒：SELECT TO_CHAR(SYSDATE,'YYYYMMDDHH24MISSSSS') FROM DUAL;

微秒：<!--StartFragment -->

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