Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help constructing SQL
On Mon, 21 Apr 2003 15:16:37 GMT, "Randy Harris"
<randy.harris_at_nospam.net> wrote:
>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
Homework hint: rhe unit of a date column is expressed in days. A day is 24 hours. Now you work out the rest, dumping the unnecessary function.
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Mon Apr 21 2003 - 12:05:43 CDT
![]() |
![]() |