select * from tablename where (fld_a + interval to_char(TRUNC(to_number(substr(fld_b,1,2))/24))||' '||to_char(MOD(to_number(substr(fld_b,1,2)),24))||':'||substr(fld_b,3,2) day to min)>sysdate
没测试,自己看看行不?
只要你fld_b的分钟数是小于59的就没问题,不然更复杂,如下:
select * from tablename where (fld_a + interval to_char((TRUNC(to_number(substr(fld_b,1,2))+TRUNC(to_number(substr(fld_b,3,2))/60))/24))||' '||to_char(MOD((to_number(substr(fld_b,1,2))+TRUNC(to_number(substr(fld_b,3,2))/60)),24))||':'||substr(fld_b,3,2) day to min)>sysdate