SQL Server 2016: Introduced AT TIME ZONE Expression to select different TIME ZONEs

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

SQL Server 2016 introduced an AT TIME ZONE Expression to select a different type of TIME ZONEs.
If your application is multi-location and distributed over the world, I would suggest applying UTC date time format on your important date-time columns.

The reason is, you can insert UTC format anywhere from the world, and while selecting those data, you can change it into local TIME ZONE. So it will give you full flexibility on your date-time columns.

Now, you can use AT TIME ZONE expression for converting your date-time value in different TIME ZONEs.

Below is a demonstration of this:

Create a table with sample record:

Use AT TIME ZONE and SELECT your date-time value in different time zones:

Using below query, You can check available time zones: