Perhaps a slight improvement is to calculate the offset in minutes as some time zones are offset by 1/2 hour, for example Newfoundland time.

DECLARE @datetoChange AS DATETIME

SELECT @datetoChange = '2009-01-01...