时间相差--失效分析

iteye_5649

于 2015-03-07 15:43:48 发布

阅读量108

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/iteye_5649/article/details/82615338

--SCL_时效分析统计
select 
 to_char(od.print_four_time,'yyyy-mm-dd hh24:mi:ss') as 打印时间,
 to_char(oh.order_date,'yyyy-mm-dd hh24:mi:ss') as 订单时间,
 trunc(to_date(to_char(od.print_four_time,'yyyy-MM-dd hh24:mi:ss') 
 ,'yyyy-MM-dd hh24:mi:ss') - to_date(to_char(oh.order_date,'yyyy-MM-dd hh24:mi:ss') 
 ,'yyyy-MM-dd hh24:mi:ss'),4)*24 as 提货时效_小时,
 trunc(to_date(to_char(od.print_four_time,'yyyy-MM-dd hh24:mi:ss') 
 ,'yyyy-MM-dd hh24:mi:ss') - to_date(to_char(oh.order_date,'yyyy-MM-dd hh24:mi:ss') 
 ,'yyyy-MM-dd hh24:mi:ss'),4)*24*60 as 提货时效_分钟
 from order_detail od  
left join order_head oh on oh.id = od.order_id 
where oh.is_print_four = 1