Re: I need a Date!

Posted in 1999

Stephen F. Cawley — Wed, 15 Sep 1999 17:42:45 -0500 — source: Informix-list mailing list archive (1991-1998)

Then you should include a photo instead of SQL ;) SC > Hello Folks, > I need to delete records for a table that have dates that are older > than one month from the today's date. The querry I cooked up is as > below. Am I right. Please help. > "SELECT a.applic_id, > a.status, > l.event, > FROM application a, > audit_log l > WHERE a.applic_id BETWEEN 1 AND 10000 > bla, bla, bla... > AND l.log_time <= CURRENT - 1 UNITS MONTH <---This's the chap > giving me a head ache. > > Thanks a ton. > sherwin