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 -> Re: Need help constructing SQL

Re: Need help constructing SQL

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 21 Apr 2003 19:05:43 +0200
Message-ID: <3598avgiink6d6gh4ikf8bts7av8hbub8g@4ax.com>


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

Original text of this message

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