Get Current Time Zone - SQL in Sixty Seconds 187
Get Current Timezone in SQL Server with this simple trick.
Subscribe for Free Performance Tuning Scripts: https://go.sqlauthority.com/
0:00 Intro
0:12 Real-World Story
00:35 Demo: Get Current Time Zone
1:33 Final Note
Script used in the video
Script 1:
SELECT CURRENT_TIMEZONE();
Script 2:
SELECT SYSDATETIMEOFFSET();
Script 3:
SELECT *
FROM sys.time_zone_info;
#SQLServer #PerformanceTuning #SQLAuthority