select sysdate,
         (sysdate+1/24/12) "Every five min",
         (sysdate+1/24/6) "Every ten min",
         (sysdate-1/24/6/5) "before two min",
         (sysdate-1/24/6) "before ten min",
         (sysdate+1/144) "Every ten min",
         (sysdate+30/1440) "Every half hour",
         (sysdate+1/24) "Every hour",
         trunc(sysdate+1) "Every day",
         trunc(sysdate+7) "Every week",
         trunc(sysdate+30) "Every month",
         trunc(sysdate+1)+6/24 "Every 6AM",
         trunc(sysdate+1)+2/24 "Every 2PM"
from dual;
Posted by enjoyer
: