24 hour query

From: Shawn Edwards <spedwards_at_qwest.net>
Date: Tue, 28 Jan 2003 16:54:12 -0700
Message-ID: <4LEZ9.460$2x3.134386@news.uswest.net>

Hi,

I run the below query at 12:00AM to update all events on our database with a certain status_code and those
that are older than the previous day. I need to change it so that I can run it at anytime and it will update those
events that are 24 hours and older. For example; I run it at 9AM Tuesday and it updates all events with that
designated status_code that are older than 9AM Monday. I'm not sure if I explained it that well but and hints
would be greatly appreciated.

update disb_basic
set status_code = 'CANCELLED'
where status_code = 'PPTINIT'
and effdate < sysdate-1;

Thanks! Received on Tue Jan 28 2003 - 17:54:12 CST