-
Calculate Duration from Date on Oracle Database
Calculate Duration Here is the example query to calculate duration in hour : select (to_date(‘2016-12-06 22:00’, ‘YYYY-MM-DD hh24:mi’) – to_date(‘2016-12-06 19:30’, ‘YYYY-MM-DD hh24:mi’)) * 24 duration_hours from dual; Result in minute : select (to_date(‘2016-12-06 22:00’, ‘YYYY-MM-DD hh24:mi’) – to_date(‘2016-12-06 19:30’, ‘YYYY-MM-DD hh24:mi’)) * 24 * 60 duration_minutes from dual; Result in second :…