Hello, You can find time difference between two times by using to_char and to_date sql functions. Use to_char(sysdate, ‘sssss’) in order to calculate seconds from midnight.
select to_char(sysdate, 'sssss') from dual;
TO_CHAR(SYSDATE,’SSSSS’) ———————— 42881 1 row selected. We can also convert seconds to time with…