check the date interval select sysdate, sysdate - (decode(mod(to_number(to_char(sysdate,'sssss')),300),0,300, mod(to_number(to_char(sysdate,'sssss')),300))+300)/(24*60*60 ) st_time, sysdate - decode(mod(to_number(to_char(sysdate,'sssss')),300),0,300, mod(to_number(to_char(sysdate,'sssss')),300))/(24*60*60 ) end_time FROM dual;
select sysdate - interval '11' minute from dual;
Select * from timetab where time_id between (sysdate-((mod(extract(minute from systimestamp),5)+5)/24/60)-((extract(second from systimestamp))/24/60/60)) and (sysdate-((mod(extract(minute from systimestamp),5)/24/60)-((extract(second from systimestamp))/24/60/60));