假设要查的时间段是v_tb(开始)和v_te(结束),那么可以这样写
select case when time_b>=v_te or time_e>=v_tb then 0
else trunc((least(time_e,v_te)-greatest(time_b,v_tb))*1440)
from t
select case when time_b>=v_te or time_e>=v_tb then 0
else trunc((least(time_e,v_te)-greatest(time_b,v_tb))*1440)
from t
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货