get local time from UTC datetime TSQL code example Example: tsql utf to local time select [MyUtcDate] + getdate() - getutcdate() from [dbo].[mytable]