tsql convert timeszone code example Example: tsql utf to local time select [MyUtcDate] + getdate() - getutcdate() from [dbo].[mytable]