• Besides

    DATEADD ( hh , (DATEDIFF ( hh , GetDate(), GetUTCDate() )) , @dt_Date_Time )

    will only deal with the current time difference between the values. Consider that Time Zones in many places shift by an 1 hour back and forth for daylight savings and standard if say you run this on Jann 1 for a Jul 1 date you values will be off by an hour (espeically in the US where the change is 1st Sunday in April and Last Sunday in October). I have previously posted code to deal with transfer from GMT to local time for Eastern Time Zone in US to show the ease and complexity of the situation.