clicksor ad

Friday, October 13, 2006

Find difference between two dates in days,hrs,mins and sec

select
trunc(to_date('15-jan-2006','dd-mon-yyyy')-sysdate)
"Days",
trunc(mod((to_date('15-jan-2006','dd-mon-yyyy')-sysdate)*24,24))
"Hrs",
trunc(mod((to_date('15-jan-2006','dd-mon-yyyy')-sysdate)*24*60,60))
"Mins",
trunc(mod((to_date('15-jan-2006','dd-mon-yyyy')-sysdate)*24*60*60,60))
"Secs"
from dual;

No comments: