Get Current Time Zone – SQL in Sixty Seconds #187

Lots of people often ask me how to get the current time zone in SQL Server when I am working on Comprehensive Database Performance Health Check. Well, the answer is pretty straightforward and explained in this SQL in Sixty Seconds Video.

Before you watch this video, I have a simple question for you. How many different timezones labels does SQL Server 2019 support. Well, I have also included the answer to that question in this video as well along with the current time zone.

Here is the script used in this video:

Script used in the video
Script 1:

SELECT CURRENT_TIMEZONE();

Script 2:

SELECT SYSDATETIMEOFFSET();

Script 3:

SELECT *
FROM sys.time_zone_info;

Here are my few recent videos and I would like to know what is your feedback about them. Do not forget to subscribe SQL in Sixty Seconds series. I hope you appreciate learning about the Last 5 SQL in Sixty Seconds Video.

• Detecting Memory Pressure – SQL in Sixty Seconds #186
• CPU Running 100% – SQL in Sixty Seconds #185
• Generate Script of SQL Server Objects – SQL in Sixty Seconds #184
• Prevent Unauthorized Index Modifications – SQL in Sixty Seconds #183
• MAX Columns Ever Existed in Table – SQL in Sixty Seconds #182
• Tuning Query Cost 100% – SQL in Sixty Seconds #181
• Queries Using Specific Index – SQL in Sixty Seconds #180
• Read Only Tables – Is it Possible? – SQL in Sixty Seconds #179
• One Scan for 3 Count Sum – SQL in Sixty Seconds #178
• SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177
• COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176

If you have any questions, you can always reach out to me on Twitter.

Reference: Pinal Dave (http://blog.SQLAuthority.com)