Why would this return a year of 1905: If @tempdate was a varchar
it would return just 2001, but by it being a dateime it returns
the year 1905.

declare @tempdate datetime
select @tempdate = (select datepart(yy,getdate()))
select @tempdate