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
select trunc(sysdate-trunc(max(lastmodified)))*24 from TABLE1 where ID=23432
No comments:
Post a Comment