Converting Minutes to Hour.Minutes
yakub21Nov 12 2008 — edited Nov 12 2008How does one convert minutes to hours.minutes as in :
with t as (
select to_date('12/11/2008 08:00:00','dd/mm/yyyy hh24:mi:ss') start_dt,
to_date('12/11/2008 15:30:00','dd/mm/yyyy hh24:mi;ss') end_dt
from dual
)
select trunc(end_dt - start_dt) * 1440) from t
/
TRUNC((END_DT-START_DT)*1440)
----------------------------------------------------
450
How do I get to generate 7.30 minutes ?
Thanks