How do I get the timezone of an SQL server?

Question

How can I query the current timezone setting for an SQL server with respect to some offset like UTC?

Answer 1

DECLARE @TimeZone VARCHAR(50)
EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\CurrentControlSet\Control\TimeZoneInformation','TimeZoneKeyName',@TimeZone OUT
SELECT @TimeZone