user2151140 user2151140 - 1 month ago 16
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.

Answer

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;