From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Date Math |
Date: | 2007-05-07 17:30:30 |
Message-ID: | Pine.LNX.4.64.0705071023400.20021@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 7 May 2007, aklaver(at)comcast(dot)net wrote:
> test=> select '01/01/04'::date +interval '3 year',current_date + interval
> '2 month';
> ?column? | ?column?
> ---------------------+---------------------
> 2007-01-01 00:00:00 | 2007-07-07 00:00:00
> (1 row)
Adrian,
I think so, but without explicit strings. The dates and intervals are in
the table, and I want the rows that meet the specified conditions.
Is the following closer to correct?
SELECT ... FROM Permits
WHERE (date_issued::DATE + INTERVAL term)
< (CURRENT_DATE + INTERVAL process_time + INTERVAL '2 week')
Thanks,
Rich
--
Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc. | Accelerator(TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Gainty | 2007-05-07 17:47:53 | Re: Postgre Sql 7.3 connection problem |
Previous Message | Rich Shepard | 2007-05-07 17:23:23 | Re: Date Math |