Home > mailing lists

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

From	Christine Penner
Subject	Re: adding years to a date field
Date	April 6, 2011 16:37:03
Msg-id	4D9C969D.8070406@fp2.ca Whole thread Raw
In response to	adding years to a date field (Christine Penner <chris@fp2.ca>)
List	pgsql-general

This worked. Thanks

Christine Penner
Ingenious Software
250-352-9495
chris@fp2.ca

On 06/04/2011 9:23 AM, Osvaldo Kussama wrote:

SELECT ii_purchased + ii_expected_life * '1 year'::interval FROM inventory_item;

From: Michael Glaesemann
Date: 06 April 2011, 16:28:12
Subject: Re: adding years to a date field

From: Scott Ribe
Date: 06 April 2011, 16:44:14
Subject: Re: temp tables not dropping at end of script