How to Calculate Duration from Two Times

[nuwanhwb87]

Hi,

I have Above table with IN Time and Out Time.

Need to calculate total Duration

Out Time - In Time

Specially How to Extract the time from Above Date Format

[Anil_Babu_Samineni]

Perhaps this

Date(Date#(IN_TIME, 'DD/MM/YYYY HH:MM:SS TT')-Date#(OUT_TIME, 'DD/MM/YYYY HH:MM:SS TT'), 'HH:MM:SS')

Or

Interval(Date#(IN_TIME, 'DD/MM/YYYY HH:MM:SS TT')-Date#(OUT_TIME, 'DD/MM/YYYY HH:MM:SS TT'), 'HH')

[nuwanhwb87]

Hi,

thanks for quick reply,

Unabel to run first code in PL/SQL Developer Error Message Emerge (ORA-00936 Missing Expression)