TODAY and CURRENT? - Mailing list pgsql-general

From Raymond Chui
Subject TODAY and CURRENT?
Date
Msg-id 3A3F80C6.64A9DF6C@noaa.gov
Whole thread Raw
Responses RE: TODAY and CURRENT?  ("Francis Solomon" <francis@stellison.co.uk>)
Re: TODAY and CURRENT?  (Mike Castle <dalgoda@ix.netcom.com>)
List pgsql-general
I have a table with columns

datetime   timestamp,
value        float(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 PostgreSQL?

Thank you!

Attachment

pgsql-general by date:

Previous
From: "Joseph"
Date:
Subject: Help me for "DBI->connect failed: Sorry, too many clients already."
Next
From: Marc SCHAEFER
Date:
Subject: Re: Help me for "DBI->connect failed: Sorry, too many clients already."