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

posted @ 2012-11-26 18:07  合肥房屋托管  阅读(1063)  评论(0编辑  收藏  举报