Search Postgresql Archives

Re: Date Math

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Monday 07 May 2007 10:56 am, Rich Shepard wrote:
> 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
With this setup you will have to use an explicit string-
date_issued + INTERVAL  term|| 'years'. This will involve constructing a 
string and passing it to INTERVAL.  The alternative is to change the column 
types of term and processing_time to interval and store the interval period 
with the interval qty i.e '1 year' for term and '400 days' for processing 
time for example. This way the you can use the values directly without 
invoking INTERVAL.

--
Adrian Klaver
aklaver@xxxxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux