Re: adding years to a date field

Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> · Wed, 06 Apr 2011 09:10:58 -0700



    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

      -- 
Christine Penner
Ingenious Software
250-352-9495
chris@xxxxxx
    
    Assuming that the field is an int, multiply the value in your years
    column by a 1-year interval:

    
    select ii_purchased + your_interval_field * '1 year'::date as date
    from inventory_item;

    
    Cheers,

    Steve