Try this:
DECLARE @datetoChange AS DATETIME
SELECT @datetoChange = '2009-01-01 12:00:00.000'
SELECT @datetoChange,
DATEDIFF(hh,GETUTCDATE(), GETDATE()) AS DIFFfromUTC,
DATEADD(hh,DATEDIFF(hh,GETUTCDATE(), GETDATE()),@datetoChange) AS modifiedDate
Source:
SQL SERVER UTC date to local time zone[
^]