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:
Post a Comment