Get Current Time Zone – SQL in Sixty Seconds #187

Get Current Time Zone - SQL in Sixty Seconds #187 187-CurrentTimeZone-YT-800x450 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.

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

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

Quest

SQL DateTime, SQL in Sixty Seconds, SQL Scripts, SQL Server
Previous Post
Detecting Memory Pressure – SQL in Sixty Seconds #186
Next Post
Data Compression for Performance – SQL in Sixty Seconds #188

Related Posts

Leave a Reply