How to find hours between sysdate and max of timestamp field
921326Jun 22 2012 — edited Jun 25 2012Hi,
Could someone help me out of this query,when iam running thIs query iam getting this error
and query is
Select trunc((Sysdate - MAX(LASTMODIFIED))*24)||':'||trunc(Mod((Sysdate-MAX(LASTMODIFIED))*24*60,60))
From STATUS_CLAIMS;
ERROR:ORA-00932:INCONSISTENT DATATYPES:EXPECTED NUMBER
GOT INTERVAL DAY TO SECOND
ACTUALLY I NEED HOURS FROM SYSDATE MINUS MAX(LASTMODIFIED) DATE,
WHERE LASTMODIFIED FIELD IS IN TIMESTAMP DATATYPE AND IT IS HAVING DEFAULT OF SYSTIMESTAMP
Any suggestions on what I am doing wrong would be greatly appreciated.
Regards,
Vikram