Write the following query to get time Current TimeZone in SQL Server:
- DECLARE @TimeZone VARCHAR(50)
-
- EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE',
-
- 'SYSTEM\CurrentControlSet\Control\TimeZoneInformation',
-
- 'TimeZoneKeyName',@TimeZone OUT
-
- SELECT @TimeZone