Oracle时间戳格式化和求差显示毫秒数

SELECT TRANSID 交易编码,
       to_CHAR( MIN(ACCEPTTIME),'yyyy-mm-dd hh24:mi:ss,ff3') 接受请求时间,
       to_CHAR( MIN(TRANSDATE),'yyyy-mm-dd hh24:mi:ss,ff3') 推送结果时间,
       EXTRACT(SECOND FROM(MAX(TRANSDATE) - MIN(ACCEPTTIME))) * 1000 处理耗时,
       EXTRACT(SECOND FROM(MAX(TRANSDATE) - MIN(TRANSDATE))) * 1000 推送耗时
  FROM TEST
 GROUP BY TRANSID
 ORDER BY 接受请求时间