By this u can get current system time zone
-------------------------------------------
DECLARE @TimeZone VARCHAR(50)
EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\Control\TimeZoneInformation',
'TimeZoneKeyName',@TimeZone OUT
SELECT @TimeZone
Now Utc to Current time Zone
-------------------------
declare @offset decimal
set @offset= (select DATEDIFF(minute,GETUTCDATE(), GETDATE() ))
select dateadd(minute, @offset,GETUTCDATE())