Re: TODAY and CURRENT?

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@ix.netcom.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