Re: I need a Date!

Posted in 1999

Sujit.Pal@bankofamerica.com — Wed, 15 Sep 1999 09:47:57 -0700 — source: Informix-list mailing list archive (1991-1998)

Sherwin Try AND l.log_time <= CURRENT - interval(1) MONTH to month <---This's the chap HTH Sujit Sherwin Jaleel <sherwin@blr.sni.de> on 09/15/99 07:45:52 AM Please respond to sherwin@blr.sni.de To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: I need a Date! 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