For SQL Server 2008 or greater you can use below code:
Or else you can use less verbose like this:
SELECT DATEADD(mi, DATEDIFF(mi, GETUTCDATE(), GETDATE()), MyTable.UtcColumn)
Note: In any case, you should not use - to subtract dates, because the operation is not atomic, sometimes you can get indeterminate results because of the race conditions between the system datetime and
the local datetime which will be checked at different times (i.e., non-atomically).