Re: SQL Test/query

From: Christian Rodemeyer <ljewin_at_web.de>
Date: Wed, 15 Nov 2000 21:03:04 +0100
Message-ID: <8uuq06$bqo$06$1@news.t-online.com>

"Tony Walby" <tony.walby_at_bridgewatersystems.com> schrieb im Newsbeitrag news:3A12DF1A.C32C6850_at_bridgewatersystems.com...
> Ok all you great sql programmers, lets see who can get this one.
> If
> nobody gets this I will post the answer tomorrow.
>
> Problem: Table description junk(last_date date, Job_name
> varchar2(30)). Query: Need to report any jobs that have been
> running for more than two hours from current time. So if last date was
> Nov. 15
> at 3:00 the system doesn't report any problems until Nov. 15 5:00.
>
> Rating: Intermediate
>
>
>

select job_name, last_date from junk where last_date < (sysdate - (1/12)) Received on Wed Nov 15 2000 - 14:03:04 CST