oracle 时间差值精确到毫秒

select round(to_number(tt.time1)*24*60*60*1000) from (select t.finish_date-t.req_date as time1 from t_ckeck_ews t where ews_id =81) tt

转载于:https://www.cnblogs.com/kunpengit/archive/2012/11/26/2789499.html

相关资源：数据结构—成绩单生成器