This discussion is archived
5 Replies Latest reply: Jan 25, 2013 12:39 PM by Solomon Yakobson RSS

query help... date from year

883189 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points