From: | Christine Penner <chris(at)fp2(dot)ca> |
---|---|
To: | Postgres-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: adding years to a date field |
Date: | 2011-04-06 16:18:15 |
Message-ID: | 4D9C9247.5010308@fp2.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This still gave me a sytax error. The other suggestion to multiply the
interval field by 1 year also gave me a syntax error.
ii_purchased is a timestamp without time zone
ii_expected_life is a smallint
Any other suggestions?
Christine Penner
Ingenious Software
250-352-9495
chris(at)fp2(dot)ca
On 06/04/2011 9:05 AM, Adrian Klaver wrote:
> On 04/06/2011 08:54 AM, Christine Penner wrote:
>> I have to add a number of years to a date field. The years come from
>> another field in the table.
>>
>> I know I can do this:
>> select (ii_purchased + interval '3 year') as date from inventory_item;
>>
>> But I need to replace the 3 in 3 years with another field from the same
>> table ii_expected_life but I can't seem to do that without getting
>> syntax errors
>
> Maybe something along lines:
> select (ii_purchased + interval year_int::text||' year') as date from
> inventory_item
>
> I am guessing at the data type of the field.
>
>>
>> --
>> Christine Penner
>> Ingenious Software
>> 250-352-9495
>> chris(at)fp2(dot)ca
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2011-04-06 16:27:51 | Re: adding years to a date field |
Previous Message | Steve Crawford | 2011-04-06 16:10:58 | Re: adding years to a date field |