Skip to main content

Posts

Showing posts from April, 2020

Get Time zone in sql server

Do you want to get timezone in sql server Here is the script DECLARE @TimeZone VARCHAR ( 50 ) EXEC MASTER .dbo. xp_regread 'HKEY_LOCAL_MACHINE' , 'SYSTEM\CurrentControlSet\Control\TimeZoneInformation' , 'TimeZoneKeyName ' , @TimeZone OUT SELECT @TimeZone