Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Need help constructing SQL
I would appreciate some help constructing a SQL statement that would return
the length of time in hours passed since a Max time of the logging table
SYNCTIME field.
In pseudo code:
SELECT CONVERT_TO_HOURS(SYSDATE-MAX(SYNCTIME)) FROM MINE.SYNCLOG Thanks for your help
-- Randy HarrisReceived on Mon Apr 21 2003 - 10:16:37 CDT