convert UTC-0 sql code example

Example: tsql utf to local time

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