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
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;