Re: Date Math

On Mon, 7 May 2007, aklaver@comcast.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