user2151140 user2151140 - 6 months ago 57
SQL Question

Working out elapsed time from two columns in ORACLE SQL

I have two rows stored in a table called client_booking. These are called start_time and end_time. I need to create a text box in ORACLE APEX which generates the elapsed time through an SQL query.


Time difference being in days, let us multiply it by no of hours 24 and no of minutes 60. Assuming they are of DATE or TIMESTAMP datatypes

select (
         to_date('01-01-2014 '|| end_time  ||'00','DD-MM-YYYY HHMISS') -
         to_date('01-01-2014 '|| start_time||'00','DD-MM-YYYY HHMISS')
       ) * 24 * 60 as time_elapsed_in_mins
from your_table;