查询请求的完成情况

Posted on 2012-02-10 17:14 奥客阅读(230) 评论(0) 编辑收藏举报

select * from
(
select crs.ACTUAL_START_DATE,crs.ACTUAL_COMPLETION_DATE

, floor(to_number(crs.ACTUAL_COMPLETION_DATE- crs.ACTUAL_START_DATE )*24*60) as spanMinutes
,crs.PROGRAM
from FND_CONC_REQ_SUMMARY_V crs where to_char( crs.ACTUAL_COMPLETION_DATE,'yyyy-mm-dd')='2012-02-10'
) a
where a.spanMinutes>5