I need to update the year only and keep the rest same. Here under is my date format:
Now run below query
SET yourDateColumn = DATEADD(year,1,yourDateColumn)
WHERE someColumn = someValue
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