Question: how to calculate hours between two dates in oracle?
Answer: select 24 * (to_date(sysdate, 'YYYY-MM-DD hh24:mi') - to_date('2012-02-28 15:20', 'YYYY-MM-DD hh24:mi')) diff_hours from dual; But that did not work.