Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
Hi,
thanks for quick reply,
Unabel to run first code in PL/SQL Developer Error Message Emerge (ORA-00936 Missing Expression)