utc date to local time of a specific date in sql server code example

Example: tsql utf to local time

select 
 [MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]