Oracle query to calculate difference of sysdate and systimestamp in hours

Below is the Oracle query which can be used to calculate number of hours between SYSDATE and timestamp


select trunc(sysdate-trunc(max(lastmodified)))*24 from TABLE1 where ID=23432

No comments:

Post a Comment