I need to update the year only and keep the rest same. Here under is my date format:
2011-03-18 00:35:13.000
Now run below query
UPDATE yourTable
SET yourDateColumn = DATEADD(year,1,yourDateColumn)
WHERE someColumn = someValue
Example :
update tbuser set CreatedOnDate=DATEADD(year,1,CreatedOnDate) where id='2'
Here in example we tbuser is table name, createdonDate is field name. After executing query, Now the output in table will be 2012-03-18 00:35:13.000