Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Relative times
What is the query and the explain plan..
Jim
"Carole Kaufman" <carolek_at_ix.netcom.com> wrote in message
news:72330e0d.0111091807.55cc5700_at_posting.google.com...
> I would like to create a query in Oracle which checks data for the
> last 4 hours. In Oracle, I know that if I want a relative day, I'd
> say "Sysdate - 1". But how do I make it go to hours? When I try
> 'sysdate - 0.17', the query takes forever to run - but it runs well
> with whole numbers. We're on Oracle 7.3.
>
> Any and all help appreciated.
Received on Fri Nov 09 2001 - 20:52:04 CST