Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Need help constructing SQL

Need help constructing SQL

From: Randy Harris <randy.harris_at_nospam.net>
Date: Mon, 21 Apr 2003 15:16:37 GMT
Message-ID: <pXToa.811$Bk5.741817@newssvr28.news.prodigy.com>


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 Harris
Received on Mon Apr 21 2003 - 10:16:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US