오라클 sysdate 사용 사례
일터 2010. 7. 9. 13:53 |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;