SQL SERVER – Convert Date Time AT TIME ZONE

I received an interesting question from my client last week about Comprehensive Database Performance Health Check. The question was how to Convert Date Time AT TIME ZONE. Let us discuss it in today’s blog post.

SQL SERVER - Convert Date Time AT TIME ZONE ATTIMEZONE-800x1019

Let us assume that you have a business where you have to display the start time of your store multiple timezones. Now if you go by the definition of the relational database and normalization you should not store multiple entries for a single time. It is better that you use the new keyword AT TIME Zone.

Let us first declare a value and store a UTC time in it. Right after that we will display that with different timezone offsets.

DECLARE @dt DATETIME2 = '2021-02-22T01:00:00'
SELECT @dt AT TIME ZONE 'Central European Standard Time' AS CEST,
@dt AT TIME ZONE 'Tokyo Standard Time' AS TST,
@dt AT TIME ZONE 'Eastern Standard Time' AS EST;

SQL SERVER - Convert Date Time AT TIME ZONE attimezone1

There are many different timezones available out there which this function support and you can check all of them with the help of the following command.

SELECT * FROM sys.time_zone_info
GO

SQL SERVER - Convert Date Time AT TIME ZONE attimezone2

Well, that’s it for today.

Here are my few recent videos and I would like to know what is your feedback about them. You can subscribe to my youtube channel here.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
Multiple Backup Copies Stripped – SQL in Sixty Seconds #156
Next Post
SQL SERVER – Fix: There is already an object named ‘MyFirstTable’ in the database

Related Posts

Leave a Reply

Menu