TODAY and CURRENT?

From: Raymond Chui <raymond(dot)chui(at)noaa(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: TODAY and CURRENT?
Date: 2000-12-19 15:37:42
Message-ID: 3A3F80C6.64A9DF6C@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
raymond.chui.vcf text/x-vcard 421 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brett W. McCoy 2000-12-19 16:18:01 Re: Auto incrementing fields. How?
Previous Message Harry Wood 2000-12-19 14:51:25 Auto incrementing fields. How?