2020-07-06
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)
计算两个时间内的点
...
原创
2020-07-06 10:17:01 ·
411 阅读 ·
0 评论