Re: Date comparison in SQL

Posted in 1994

Paul Roberts — 3 May 1994 01:44:19 GMT — source: Informix-list mailing list archive (1991-1998)

In article <matuscak-020594165521@zaphod.rohrer.com> matuscak@rohrer.com (Joe Matuscak) writes: >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? How about: delete from userlog where timestamp < today - 182 ? Paul