carolek_at_ix.netcom.com (Carole Kaufman) wrote in message news:<72330e0d.0111132002.7d50c638_at_posting.google.com>...
> I want to pull records for the past 4.5 hours, based on the time the
> query runs. I know that if I want records for the past 24 hours, I
> say:
>
> Last_Update_Tstamp>= (sysdate-1)
>
> This runs fast; I'm happy. BUT, how do I get the past 4.5 hours? In
> DB2 I'd add 'hours' after 4.5, but this is Oracle. So I tried
>
> Last_Update_Tstamp>=(Sysdate - 0.19).
>
> This runs slowly if at all...so it must be wrong.
>
> What is the right way?
Hallo Carole,
please try: Last_Update_Tstamp>= (sysdate-4.5/24)
Best Regards
Jens Loebling
Received on Wed Nov 14 2001 - 09:50:17 CST
