프로그래밍/DB
[펌]DATE의 기간을 계산하는 방법
galad
2008. 1. 9. 17:40
$ sqlplus scott/tiger
SQL> select trunc(date2-date1) || ` day ` ||
trunc(mod((date2-date1),1)*24) || ` hour ` ||
trunc(mod((date2-date1)*24,1)*60) || ` minute ` ||
trunc(round(mod((date2-date1)*24*60,1)*60)) || ` sec `
" Time Interval "
from dual;
SQL> select trunc(date2-date1) || ` day ` ||
trunc(mod((date2-date1),1)*24) || ` hour ` ||
trunc(mod((date2-date1)*24,1)*60) || ` minute ` ||
trunc(round(mod((date2-date1)*24*60,1)*60)) || ` sec `
" Time Interval "
from dual;