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 13:37:03
Msg-id	[email protected] Whole thread Raw
In response to	adding years to a date field (Christine Penner <[email protected]>)
List	pgsql-general

This worked. Thanks

Christine Penner
Ingenious Software
250-352-9495
[email protected]

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, 13:28:12
Subject: Re: adding years to a date field

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