select ceil((to_number(substr(startime,0,2))*60+to_number(substr(startime,4)))/5)+1 from dual
当前时间对应的286的点
select replace(to_char(wm_concat(‘p’ ||(v_num + 1 + LEVEL - 1))), ‘,’ , ‘+’) from dual CONNECT BY LEVEL<=(v_endnum - v_num)
计算两个时间内的点
select ceil((to_number(substr(startime,0,2))*60+to_number(substr(startime,4)))/5)+1 from dual
当前时间对应的286的点
select replace(to_char(wm_concat(‘p’ ||(v_num + 1 + LEVEL - 1))), ‘,’ , ‘+’) from dual CONNECT BY LEVEL<=(v_endnum - v_num)
计算两个时间内的点