Postgres Pro
Downloads
Home   >   mailing lists

Re: adding years to a date field - Mailing list pgsql-general

From John R Pierce
Subject Re: adding years to a date field
Date
Msg-id 4D9CBEFB.3010507@hogranch.com
Whole thread Raw
In response to Re: adding years to a date field  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: adding years to a date field
List pgsql-general
Tree view 
On 04/06/11 9:10 AM, Steve Crawford wrote:
> select ii_purchased + your_interval_field * '1 year'::date as date
> from inventory_item;

that SHOULD be written as...

select ii_purchased + your_interval_field * interval '1 year' as date
from inventory_item;

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: adding years to a date field
Next
From: Rich Shepard
Date:
Subject: Postgres-9.x - ADODB - PHP