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 cl
Hi Raymond,
You might try something like this:
DELETE FROM tablename WHERE datetime < ('now'::timestamp - '10
days'::interval);
and
DELETE FROM tablename WHERE datetime BETWEEN ('now'::timestamp - '10
hours'::interval) AND 'now'::timestamp;
If you just want the date stamp, you can use 'now'::da
I have a table with columns
datetime timestamp,
valuefloat(8)
I want to delete rows 10 days older or 10 hours older by
delete from tablename where datetime < TODAY-10;
or
delete from tablename where datetime between CURRENT-10 and CURRENT;
So are there key words TODAY, CURRENT in Pos
