Re: adding years to a date field

Christine Penner <chris@xxxxxx> · Wed, 06 Apr 2011 09:18:15 -0700



    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@xxxxxx
    

    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@xxxxxx