How To Change Just Year from a column(DueDate)

Hi
I am getting problem in changing just year from a column name duedate
in order to do m getting all months and day are also changing
help me out

Quote:

Originally Posted by lokaish

Hi
I am getting problem in changing just year from a column name duedate
in order to do m getting all months and day are also changing
help me out

Hey try this...

update tablename set duedate=dateadd(year,2,getdate())