5 Replies Latest reply on Jan 25, 2013 8:39 PM by Solomon Yakobson

    query help... date from year

    883189
      I wanted to update one of the column in the table.
      That column is of date datatype
      Only the year needs to be replaced with another year
      For example:
      currently the column data looks like this
      date
      2/16/2010
      5/20/2010
      10/30/2010
      6/24/2010
      6/24/2010
      7/26/2010
      6/1/2010

      The output should be:
      date
      2/16/2015
      5/20/2015
      10/30/2015
      6/24/2015
      6/24/2015
      7/26/2015
      6/1/2015