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

On 04/06/2011 12:28 PM, John R Pierce wrote:
> 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;
>
>
>
Correct. I meant ...::interval... but hadn't had my first coffee. :)

Cheers,
Steve