Date diff

You have table a with col t and f, to get diff of dates

select trunc( t-f ) "Day",
trunc( mod( (t-f)*24, 24 ) ) "Hr",
trunc( mod( (t-f)*24*60, 60 ) ) "Mi"
from a;