Re: adding years to a date field

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;