Re: Date Math

On Mon, 7 May 2007, Adrian Klaver wrote:

> If term and process_time are stored as intervals then it will work. Also
> if they are stored as INTERVALS you can do CURRENT_DATE+process_time. In
> other words not have to declare the INTERVAL . Is date_issued stored as a
> date? If so it would not need to be cast.

Adrian,

   Here are the pertinent declarations in the DDL:

   date_issued DATE NOT NULL
     CONSTRAINT invalid_date
       CHECK (date_applied <= date_issued),
   term SMALLINT DEFAULT 1 NOT NULL,                  -- in years
   processing_time DEFAULT 180 NOT NULL SMALLINT,     -- in days

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