Re: adding years to a date field

From: Christine Penner <chris(at)fp2(dot)ca>
To: Osvaldo Kussama <osvaldo(dot)kussama(at)gmail(dot)com>
Cc: Postgres-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: adding years to a date field
Date: 2011-04-06 16:36:45
Message-ID: 4D9C969D.8070406@fp2.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This worked. Thanks

Christine Penner
Ingenious Software
250-352-9495
chris(at)fp2(dot)ca

On 06/04/2011 9:23 AM, Osvaldo Kussama wrote:
> SELECT ii_purchased + ii_expected_life * '1 year'::interval FROM inventory_item;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2011-04-06 16:43:53 Re: temp tables not dropping at end of script
Previous Message Michael Glaesemann 2011-04-06 16:27:51 Re: adding years to a date field