Just add the following in the select list

(YEAR - 1) AS PreYear

Have a similar solution using dateadd and datediff.

declare @d datetime

set @d = '2010-04-04'

update dateupdate set [date] = DATEADD(dd, DATEDIFF(dd, [date], @d), [date]) where id = 1

Regads,

http://www.ms-sql-server.com