반응형
두개의 날짜를 받아서 차이를 초(second) 로 계산
select ((endate - stdate)*24*60*60) as elapseconds
from
(
select
to_date('20071231235959', 'YYYYMMDDHH24MISS') stdate,
to_date('20080101010101', 'YYYYMMDDHH24MISS') endate
from dual
);
select ((endate - stdate)*24*60*60) as elapseconds
from
(
select
to_date('20071231235959', 'YYYYMMDDHH24MISS') stdate,
to_date('20080101010101', 'YYYYMMDDHH24MISS') endate
from dual
);
반응형
