Date comparison in SQL

Posted in 1994

Joe Matuscak — Mon, 02 May 1994 16:55:21 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi. Ive got a table that is used for logging information about when a program is run. Among other things, its got a date field in it. Id like to have my nightly cron job run some SQL that basically says "delete from userlog where timestamp is older than 6 months". Can someone shed some light on how to do that? -- Joe Matuscak Rohrer Corporation 717 Seville Road Wadsworth, Ohio 44281 (216)335-1541 Matuscak@Rohrer.com