How to determine the timezone of SQL server? Get link Facebook X Pinterest Email Other Apps February 28, 2020 SELECT SYSDATETIMEOFFSET() DECLARE @TimeZone VARCHAR(50) EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE', 'SYSTEM\CurrentControlSet\Control\TimeZoneInformation', 'TimeZoneKeyName',@TimeZone OUT SELECT @TimeZone Get link Facebook X Pinterest Email Other Apps Comments
Comments
Post a Comment