On Tue, Dec 19, 2000 at 10:37:42AM -0500, Raymond Chui wrote:
> delete from tablename where datetime < TODAY-10;
delete from tablename where datetime < timestamp 'now' - interval '10 days';
or
delete from tablename where age(datetime) > '10 days';
--
Mike Castle Life is like a clock: You can work constantly
dalgoda(at)ix(dot)netcom(dot)com and be right all the time, or not work at all
www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc
We are all of us living in the shadow of Manhattan. -- Watchmen