Skip to main content

Convert UTC to the Local Time Zone and Vice Versa in T-SQL, with Automatic Handling of Daylight Saving Time changes.

With the introduction of the AT TIME ZONE feature in SQL Server 2016, what once plagued developers as convoluted datetime conversions has now transformed into an effortless endeavor. This feature has turned the tide, simplifying the conversion process and rendering these intricate date-time transformations far more manageable.

You can use this Fiddle to follow along and practice using AT TIME ZONE clause to convert UTC to Local time and vice versa

Convert UTC to Local Time Zones​

This T-SQL code below demonstrates how to generate and store a series of time conversions between different time zones using the AT TIME ZONE clause. Here's a breakdown of what the code does:

  1. It begins by declaring a variable @IsSourceTimeZoneUTC as a bit flag. This variable controls whether the source time zone should be UTC (1) or the current time zone (0).

  2. A table variable named @Results is created to store the results of the time conversions.

  3. Another table variable @TimeZoneTable is established to store the list of time zone names obtained from the sys.time_zone_info system table.

  4. The @TimeZoneTable is populated with time zone names.

  5. A cursor named TimeZoneCursor is declared to loop through the time zones stored in @TimeZoneTable.

  6. The cursor loop begins with opening the TimeZoneCursor and fetching the first time zone (@CurrentTimeZone) from the table.

  7. Within the loop, two conditional branches are used to perform conversions based on the value of @IsSourceTimeZoneUTC. If @IsSourceTimeZoneUTC is 1, the conversion is from UTC to the current time zone; otherwise, it's from the current time zone to UTC.

  8. Inside each conditional branch, the converted data is inserted into the @Results table along with the original data and a SQL query string representing the conversion.

  9. The cursor loop continues by fetching the next time zone from the table until all time zones have been processed.

  10. Once the cursor loop is done, the cursor is closed and deallocated to free up resources.

  11. The final step involves selecting all the data stored in the @Results table, which displays the details of the performed time zone conversions.

This script allows you to systematically convert times between various time zones, capturing both the source and target time zone details, the converted times, and the corresponding SQL query for each conversion. It provides a practical illustration of how the AT TIME ZONE clause can be utilized in different scenarios.

Convert UTC to Local Time Zones
DECLARE @IsSourceTimeZoneUTC BIT = 1;

DECLARE @Results TABLE
(
    SourceTimeZone NVARCHAR(100),
    SourceTime DATETIME,
    TargetTimeZone NVARCHAR(100),
    TargetTime DATETIMEOFFSET,
    SelectQuery NVARCHAR(100)
)

-- Populate the @TimeZoneTable with the time zones from sys.time_zone_info
DECLARE @TimeZoneTable TABLE
(
    TimeZoneName NVARCHAR(100)
)

INSERT INTO @TimeZoneTable
SELECT name
FROM sys.time_zone_info;

DECLARE @CurrentTimeZone NVARCHAR(100);

-- Declare a cursor to loop through the time zones
DECLARE TimeZoneCursor CURSOR FOR SELECT TimeZoneName FROM @TimeZoneTable;

OPEN TimeZoneCursor;

FETCH NEXT FROM TimeZoneCursor
INTO @CurrentTimeZone;

-- Loop through each time zone and perform time conversion
WHILE @@FETCH_STATUS = 0
BEGIN

    IF (@IsSourceTimeZoneUTC = 1)
    BEGIN
        INSERT INTO @Results
        (
            SourceTimeZone,
            SourceTime,
            TargetTimeZone,
            TargetTime,
            SelectQuery
        )
        SELECT 'UTC',
               GETUTCDATE(),
               @CurrentTimeZone,
               GETUTCDATE()AT TIME ZONE 'UTC' AT TIME ZONE @CurrentTimeZone,
               CONCAT('SELECT GETUTCDATE() AT TIME ZONE ''UTC'' AT TIME ZONE ''', @CurrentTimeZone, '''');
    END
    ELSE
    BEGIN
        INSERT INTO @Results
        (
            SourceTimeZone,
            SourceTime,
            TargetTimeZone,
            TargetTime,
            SelectQuery
        )
        SELECT @CurrentTimeZone,
               GETDATE(),
               'UTC',
               GETDATE()AT TIME ZONE @CurrentTimeZone AT TIME ZONE 'UTC',
               CONCAT('SELECT GETDATE() AT TIME ZONE ''', @CurrentTimeZone, ''' AT TIME ZONE ''UTC''');
    END

    FETCH NEXT FROM TimeZoneCursor
    INTO @CurrentTimeZone;
END

CLOSE TimeZoneCursor;

DEALLOCATE TimeZoneCursor;

SELECT *
FROM @Results
SourceTimeZoneSourceTimeTargetTimeZoneTargetTimeSelectQuery
UTC2023-08-18 20:57:20.430Dateline Standard Time2023-08-18 08:57:20.4300000 -12:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Dateline Standard Time'
UTC2023-08-18 20:57:20.430UTC-112023-08-18 09:57:20.4300000 -11:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'UTC-11'
UTC2023-08-18 20:57:20.430Aleutian Standard Time2023-08-18 11:57:20.4300000 -09:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Aleutian Standard Time'
UTC2023-08-18 20:57:20.430Hawaiian Standard Time2023-08-18 10:57:20.4300000 -10:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Hawaiian Standard Time'
UTC2023-08-18 20:57:20.430Marquesas Standard Time2023-08-18 11:27:20.4300000 -09:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Marquesas Standard Time'
UTC2023-08-18 20:57:20.430Alaskan Standard Time2023-08-18 12:57:20.4300000 -08:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Alaskan Standard Time'
UTC2023-08-18 20:57:20.430UTC-092023-08-18 11:57:20.4300000 -09:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'UTC-09'
UTC2023-08-18 20:57:20.430Pacific Standard Time (Mexico)2023-08-18 13:57:20.4300000 -07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time (Mexico)'
UTC2023-08-18 20:57:20.430UTC-082023-08-18 12:57:20.4300000 -08:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'UTC-08'
UTC2023-08-18 20:57:20.433Pacific Standard Time2023-08-18 13:57:20.4330000 -07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time'
UTC2023-08-18 20:57:20.433US Mountain Standard Time2023-08-18 13:57:20.4330000 -07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'US Mountain Standard Time'
UTC2023-08-18 20:57:20.433Mountain Standard Time (Mexico)2023-08-18 13:57:20.4330000 -07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Mountain Standard Time (Mexico)'
UTC2023-08-18 20:57:20.433Mountain Standard Time2023-08-18 14:57:20.4330000 -06:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Mountain Standard Time'
UTC2023-08-18 20:57:20.433Yukon Standard Time2023-08-18 13:57:20.4330000 -07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Yukon Standard Time'
UTC2023-08-18 20:57:20.433Central America Standard Time2023-08-18 14:57:20.4330000 -06:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Central America Standard Time'
UTC2023-08-18 20:57:20.433Central Standard Time2023-08-18 15:57:20.4330000 -05:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Central Standard Time'
UTC2023-08-18 20:57:20.433Easter Island Standard Time2023-08-18 14:57:20.4330000 -06:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Easter Island Standard Time'
UTC2023-08-18 20:57:20.433Central Standard Time (Mexico)2023-08-18 14:57:20.4330000 -06:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Central Standard Time (Mexico)'
UTC2023-08-18 20:57:20.433Canada Central Standard Time2023-08-18 14:57:20.4330000 -06:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Canada Central Standard Time'
UTC2023-08-18 20:57:20.433SA Pacific Standard Time2023-08-18 15:57:20.4330000 -05:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'SA Pacific Standard Time'
UTC2023-08-18 20:57:20.433Eastern Standard Time (Mexico)2023-08-18 15:57:20.4330000 -05:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Eastern Standard Time (Mexico)'
UTC2023-08-18 20:57:20.433Eastern Standard Time2023-08-18 16:57:20.4330000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Eastern Standard Time'
UTC2023-08-18 20:57:20.437Haiti Standard Time2023-08-18 16:57:20.4370000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Haiti Standard Time'
UTC2023-08-18 20:57:20.437Cuba Standard Time2023-08-18 16:57:20.4370000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Cuba Standard Time'
UTC2023-08-18 20:57:20.437US Eastern Standard Time2023-08-18 16:57:20.4370000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'US Eastern Standard Time'
UTC2023-08-18 20:57:20.437Turks And Caicos Standard Time2023-08-18 16:57:20.4370000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Turks And Caicos Standard Time'
UTC2023-08-18 20:57:20.437Paraguay Standard Time2023-08-18 16:57:20.4370000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Paraguay Standard Time'
UTC2023-08-18 20:57:20.437Atlantic Standard Time2023-08-18 17:57:20.4370000 -03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Atlantic Standard Time'
UTC2023-08-18 20:57:20.437Venezuela Standard Time2023-08-18 16:57:20.4370000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Venezuela Standard Time'
UTC2023-08-18 20:57:20.437Central Brazilian Standard Time2023-08-18 16:57:20.4370000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Central Brazilian Standard Time'
UTC2023-08-18 20:57:20.437SA Western Standard Time2023-08-18 16:57:20.4370000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'SA Western Standard Time'
UTC2023-08-18 20:57:20.437Pacific SA Standard Time2023-08-18 16:57:20.4370000 -04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific SA Standard Time'
UTC2023-08-18 20:57:20.437Newfoundland Standard Time2023-08-18 18:27:20.4370000 -02:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Newfoundland Standard Time'
UTC2023-08-18 20:57:20.437Tocantins Standard Time2023-08-18 17:57:20.4370000 -03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Tocantins Standard Time'
UTC2023-08-18 20:57:20.437E. South America Standard Time2023-08-18 17:57:20.4370000 -03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'E. South America Standard Time'
UTC2023-08-18 20:57:20.440SA Eastern Standard Time2023-08-18 17:57:20.4400000 -03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'SA Eastern Standard Time'
UTC2023-08-18 20:57:20.440Argentina Standard Time2023-08-18 17:57:20.4400000 -03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Argentina Standard Time'
UTC2023-08-18 20:57:20.440Greenland Standard Time2023-08-18 18:57:20.4400000 -02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Greenland Standard Time'
UTC2023-08-18 20:57:20.440Montevideo Standard Time2023-08-18 17:57:20.4400000 -03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Montevideo Standard Time'
UTC2023-08-18 20:57:20.440Magallanes Standard Time2023-08-18 17:57:20.4400000 -03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Magallanes Standard Time'
UTC2023-08-18 20:57:20.440Saint Pierre Standard Time2023-08-18 18:57:20.4400000 -02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Saint Pierre Standard Time'
UTC2023-08-18 20:57:20.440Bahia Standard Time2023-08-18 17:57:20.4400000 -03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Bahia Standard Time'
UTC2023-08-18 20:57:20.440UTC-022023-08-18 18:57:20.4400000 -02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'UTC-02'
UTC2023-08-18 20:57:20.440Mid-Atlantic Standard Time2023-08-18 19:57:20.4400000 -01:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Mid-Atlantic Standard Time'
UTC2023-08-18 20:57:20.440Azores Standard Time2023-08-18 20:57:20.4400000 +00:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Azores Standard Time'
UTC2023-08-18 20:57:20.440Cape Verde Standard Time2023-08-18 19:57:20.4400000 -01:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Cape Verde Standard Time'
UTC2023-08-18 20:57:20.440UTC2023-08-18 20:57:20.4400000 +00:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'UTC'
UTC2023-08-18 20:57:20.440GMT Standard Time2023-08-18 21:57:20.4400000 +01:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'GMT Standard Time'
UTC2023-08-18 20:57:20.440Greenwich Standard Time2023-08-18 20:57:20.4400000 +00:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Greenwich Standard Time'
UTC2023-08-18 20:57:20.440Sao Tome Standard Time2023-08-18 20:57:20.4400000 +00:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Sao Tome Standard Time'
UTC2023-08-18 20:57:20.440Morocco Standard Time2023-08-18 21:57:20.4400000 +01:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Morocco Standard Time'
UTC2023-08-18 20:57:20.440W. Europe Standard Time2023-08-18 22:57:20.4400000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'W. Europe Standard Time'
UTC2023-08-18 20:57:20.440Central Europe Standard Time2023-08-18 22:57:20.4400000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Central Europe Standard Time'
UTC2023-08-18 20:57:20.440Romance Standard Time2023-08-18 22:57:20.4400000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Romance Standard Time'
UTC2023-08-18 20:57:20.440Central European Standard Time2023-08-18 22:57:20.4400000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Central European Standard Time'
UTC2023-08-18 20:57:20.443W. Central Africa Standard Time2023-08-18 21:57:20.4430000 +01:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'W. Central Africa Standard Time'
UTC2023-08-18 20:57:20.443GTB Standard Time2023-08-18 23:57:20.4430000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'GTB Standard Time'
UTC2023-08-18 20:57:20.443Middle East Standard Time2023-08-18 23:57:20.4430000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Middle East Standard Time'
UTC2023-08-18 20:57:20.443Egypt Standard Time2023-08-18 23:57:20.4430000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Egypt Standard Time'
UTC2023-08-18 20:57:20.443E. Europe Standard Time2023-08-18 23:57:20.4430000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'E. Europe Standard Time'
UTC2023-08-18 20:57:20.443Syria Standard Time2023-08-18 23:57:20.4430000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Syria Standard Time'
UTC2023-08-18 20:57:20.443West Bank Standard Time2023-08-18 23:57:20.4430000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'West Bank Standard Time'
UTC2023-08-18 20:57:20.443South Africa Standard Time2023-08-18 22:57:20.4430000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'South Africa Standard Time'
UTC2023-08-18 20:57:20.443FLE Standard Time2023-08-18 23:57:20.4430000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'FLE Standard Time'
UTC2023-08-18 20:57:20.443Israel Standard Time2023-08-18 23:57:20.4430000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Israel Standard Time'
UTC2023-08-18 20:57:20.443South Sudan Standard Time2023-08-18 22:57:20.4430000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'South Sudan Standard Time'
UTC2023-08-18 20:57:20.443Kaliningrad Standard Time2023-08-18 22:57:20.4430000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Kaliningrad Standard Time'
UTC2023-08-18 20:57:20.443Sudan Standard Time2023-08-18 22:57:20.4430000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Sudan Standard Time'
UTC2023-08-18 20:57:20.443Libya Standard Time2023-08-18 22:57:20.4430000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Libya Standard Time'
UTC2023-08-18 20:57:20.443Namibia Standard Time2023-08-18 22:57:20.4430000 +02:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Namibia Standard Time'
UTC2023-08-18 20:57:20.447Jordan Standard Time2023-08-18 23:57:20.4470000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Jordan Standard Time'
UTC2023-08-18 20:57:20.447Arabic Standard Time2023-08-18 23:57:20.4470000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Arabic Standard Time'
UTC2023-08-18 20:57:20.447Turkey Standard Time2023-08-18 23:57:20.4470000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Turkey Standard Time'
UTC2023-08-18 20:57:20.447Arab Standard Time2023-08-18 23:57:20.4470000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Arab Standard Time'
UTC2023-08-18 20:57:20.447Belarus Standard Time2023-08-18 23:57:20.4470000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Belarus Standard Time'
UTC2023-08-18 20:57:20.447Russian Standard Time2023-08-18 23:57:20.4470000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Russian Standard Time'
UTC2023-08-18 20:57:20.447E. Africa Standard Time2023-08-18 23:57:20.4470000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'E. Africa Standard Time'
UTC2023-08-18 20:57:20.447Volgograd Standard Time2023-08-18 23:57:20.4470000 +03:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Volgograd Standard Time'
UTC2023-08-18 20:57:20.447Iran Standard Time2023-08-19 00:27:20.4470000 +03:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Iran Standard Time'
UTC2023-08-18 20:57:20.447Arabian Standard Time2023-08-19 00:57:20.4470000 +04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Arabian Standard Time'
UTC2023-08-18 20:57:20.447Astrakhan Standard Time2023-08-19 00:57:20.4470000 +04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Astrakhan Standard Time'
UTC2023-08-18 20:57:20.447Azerbaijan Standard Time2023-08-19 00:57:20.4470000 +04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Azerbaijan Standard Time'
UTC2023-08-18 20:57:20.447Russia Time Zone 32023-08-19 00:57:20.4470000 +04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Russia Time Zone 3'
UTC2023-08-18 20:57:20.447Mauritius Standard Time2023-08-19 00:57:20.4470000 +04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Mauritius Standard Time'
UTC2023-08-18 20:57:20.450Saratov Standard Time2023-08-19 00:57:20.4500000 +04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Saratov Standard Time'
UTC2023-08-18 20:57:20.450Georgian Standard Time2023-08-19 00:57:20.4500000 +04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Georgian Standard Time'
UTC2023-08-18 20:57:20.450Caucasus Standard Time2023-08-19 00:57:20.4500000 +04:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Caucasus Standard Time'
UTC2023-08-18 20:57:20.450Afghanistan Standard Time2023-08-19 01:27:20.4500000 +04:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Afghanistan Standard Time'
UTC2023-08-18 20:57:20.450West Asia Standard Time2023-08-19 01:57:20.4500000 +05:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'West Asia Standard Time'
UTC2023-08-18 20:57:20.450Ekaterinburg Standard Time2023-08-19 01:57:20.4500000 +05:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Ekaterinburg Standard Time'
UTC2023-08-18 20:57:20.450Pakistan Standard Time2023-08-19 01:57:20.4500000 +05:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Pakistan Standard Time'
UTC2023-08-18 20:57:20.450Qyzylorda Standard Time2023-08-19 01:57:20.4500000 +05:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Qyzylorda Standard Time'
UTC2023-08-18 20:57:20.450India Standard Time2023-08-19 02:27:20.4500000 +05:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'India Standard Time'
UTC2023-08-18 20:57:20.450Sri Lanka Standard Time2023-08-19 02:27:20.4500000 +05:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Sri Lanka Standard Time'
UTC2023-08-18 20:57:20.450Nepal Standard Time2023-08-19 02:42:20.4500000 +05:45SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Nepal Standard Time'
UTC2023-08-18 20:57:20.450Central Asia Standard Time2023-08-19 02:57:20.4500000 +06:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Central Asia Standard Time'
UTC2023-08-18 20:57:20.450Bangladesh Standard Time2023-08-19 02:57:20.4500000 +06:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Bangladesh Standard Time'
UTC2023-08-18 20:57:20.450Omsk Standard Time2023-08-19 02:57:20.4500000 +06:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Omsk Standard Time'
UTC2023-08-18 20:57:20.450Myanmar Standard Time2023-08-19 03:27:20.4500000 +06:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Myanmar Standard Time'
UTC2023-08-18 20:57:20.450SE Asia Standard Time2023-08-19 03:57:20.4500000 +07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'SE Asia Standard Time'
UTC2023-08-18 20:57:20.450Altai Standard Time2023-08-19 03:57:20.4500000 +07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Altai Standard Time'
UTC2023-08-18 20:57:20.450W. Mongolia Standard Time2023-08-19 03:57:20.4500000 +07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'W. Mongolia Standard Time'
UTC2023-08-18 20:57:20.450North Asia Standard Time2023-08-19 03:57:20.4500000 +07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'North Asia Standard Time'
UTC2023-08-18 20:57:20.450N. Central Asia Standard Time2023-08-19 03:57:20.4500000 +07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'N. Central Asia Standard Time'
UTC2023-08-18 20:57:20.450Tomsk Standard Time2023-08-19 03:57:20.4500000 +07:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Tomsk Standard Time'
UTC2023-08-18 20:57:20.453China Standard Time2023-08-19 04:57:20.4530000 +08:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'China Standard Time'
UTC2023-08-18 20:57:20.453North Asia East Standard Time2023-08-19 04:57:20.4530000 +08:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'North Asia East Standard Time'
UTC2023-08-18 20:57:20.453Singapore Standard Time2023-08-19 04:57:20.4530000 +08:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Singapore Standard Time'
UTC2023-08-18 20:57:20.453W. Australia Standard Time2023-08-19 04:57:20.4530000 +08:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'W. Australia Standard Time'
UTC2023-08-18 20:57:20.453Taipei Standard Time2023-08-19 04:57:20.4530000 +08:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Taipei Standard Time'
UTC2023-08-18 20:57:20.453Ulaanbaatar Standard Time2023-08-19 04:57:20.4530000 +08:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Ulaanbaatar Standard Time'
UTC2023-08-18 20:57:20.453Aus Central W. Standard Time2023-08-19 05:42:20.4530000 +08:45SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Aus Central W. Standard Time'
UTC2023-08-18 20:57:20.453Transbaikal Standard Time2023-08-19 05:57:20.4530000 +09:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Transbaikal Standard Time'
UTC2023-08-18 20:57:20.453Tokyo Standard Time2023-08-19 05:57:20.4530000 +09:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Tokyo Standard Time'
UTC2023-08-18 20:57:20.453North Korea Standard Time2023-08-19 05:57:20.4530000 +09:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'North Korea Standard Time'
UTC2023-08-18 20:57:20.453Korea Standard Time2023-08-19 05:57:20.4530000 +09:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Korea Standard Time'
UTC2023-08-18 20:57:20.453Yakutsk Standard Time2023-08-19 05:57:20.4530000 +09:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Yakutsk Standard Time'
UTC2023-08-18 20:57:20.453Cen. Australia Standard Time2023-08-19 06:27:20.4530000 +09:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Cen. Australia Standard Time'
UTC2023-08-18 20:57:20.453AUS Central Standard Time2023-08-19 06:27:20.4530000 +09:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'AUS Central Standard Time'
UTC2023-08-18 20:57:20.453E. Australia Standard Time2023-08-19 06:57:20.4530000 +10:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'E. Australia Standard Time'
UTC2023-08-18 20:57:20.457AUS Eastern Standard Time2023-08-19 06:57:20.4570000 +10:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'AUS Eastern Standard Time'
UTC2023-08-18 20:57:20.457West Pacific Standard Time2023-08-19 06:57:20.4570000 +10:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'West Pacific Standard Time'
UTC2023-08-18 20:57:20.457Tasmania Standard Time2023-08-19 06:57:20.4570000 +10:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Tasmania Standard Time'
UTC2023-08-18 20:57:20.457Vladivostok Standard Time2023-08-19 06:57:20.4570000 +10:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Vladivostok Standard Time'
UTC2023-08-18 20:57:20.457Lord Howe Standard Time2023-08-19 07:27:20.4570000 +10:30SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Lord Howe Standard Time'
UTC2023-08-18 20:57:20.457Bougainville Standard Time2023-08-19 07:57:20.4570000 +11:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Bougainville Standard Time'
UTC2023-08-18 20:57:20.457Russia Time Zone 102023-08-19 07:57:20.4570000 +11:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Russia Time Zone 10'
UTC2023-08-18 20:57:20.457Magadan Standard Time2023-08-19 07:57:20.4570000 +11:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Magadan Standard Time'
UTC2023-08-18 20:57:20.457Norfolk Standard Time2023-08-19 07:57:20.4570000 +11:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Norfolk Standard Time'
UTC2023-08-18 20:57:20.457Sakhalin Standard Time2023-08-19 07:57:20.4570000 +11:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Sakhalin Standard Time'
UTC2023-08-18 20:57:20.457Central Pacific Standard Time2023-08-19 07:57:20.4570000 +11:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Central Pacific Standard Time'
UTC2023-08-18 20:57:20.457Russia Time Zone 112023-08-19 08:57:20.4570000 +12:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Russia Time Zone 11'
UTC2023-08-18 20:57:20.457New Zealand Standard Time2023-08-19 08:57:20.4570000 +12:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'New Zealand Standard Time'
UTC2023-08-18 20:57:20.457UTC+122023-08-19 08:57:20.4570000 +12:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'UTC+12'
UTC2023-08-18 20:57:20.457Fiji Standard Time2023-08-19 08:57:20.4570000 +12:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Fiji Standard Time'
UTC2023-08-18 20:57:20.460Kamchatka Standard Time2023-08-19 09:57:20.4600000 +13:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Kamchatka Standard Time'
UTC2023-08-18 20:57:20.460Chatham Islands Standard Time2023-08-19 09:42:20.4600000 +12:45SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Chatham Islands Standard Time'
UTC2023-08-18 20:57:20.460UTC+132023-08-19 09:57:20.4600000 +13:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'UTC+13'
UTC2023-08-18 20:57:20.460Tonga Standard Time2023-08-19 09:57:20.4600000 +13:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Tonga Standard Time'
UTC2023-08-18 20:57:20.460Samoa Standard Time2023-08-19 09:57:20.4600000 +13:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Samoa Standard Time'
UTC2023-08-18 20:57:20.460Line Islands Standard Time2023-08-19 10:57:20.4600000 +14:00SELECT GETUTCDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Line Islands Standard Time'

Convert Local Time to UTC​

This is the same query as above except we set @IsSourceTimeZoneUTC to 0 to demonstrate converting Local time zone to UTC.

Convert Local Time to UTC
DECLARE @IsSourceTimeZoneUTC BIT = 0;

DECLARE @Results TABLE
(
    SourceTimeZone NVARCHAR(100),
    SourceTime DATETIME,
    TargetTimeZone NVARCHAR(100),
    TargetTime DATETIMEOFFSET,
    SelectQuery NVARCHAR(100)
)

-- Populate the @TimeZoneTable with the time zones from sys.time_zone_info
DECLARE @TimeZoneTable TABLE
(
    TimeZoneName NVARCHAR(100)
)

INSERT INTO @TimeZoneTable
SELECT name
FROM sys.time_zone_info;

DECLARE @CurrentTimeZone NVARCHAR(100);

-- Declare a cursor to loop through the time zones
DECLARE TimeZoneCursor CURSOR FOR SELECT TimeZoneName FROM @TimeZoneTable;

OPEN TimeZoneCursor;

FETCH NEXT FROM TimeZoneCursor
INTO @CurrentTimeZone;

-- Loop through each time zone and perform time conversion
WHILE @@FETCH_STATUS = 0
BEGIN

    IF (@IsSourceTimeZoneUTC = 1)
    BEGIN
        INSERT INTO @Results
        (
            SourceTimeZone,
            SourceTime,
            TargetTimeZone,
            TargetTime,
            SelectQuery
        )
        SELECT 'UTC',
               GETUTCDATE(),
               @CurrentTimeZone,
               GETUTCDATE()AT TIME ZONE 'UTC' AT TIME ZONE @CurrentTimeZone,
               CONCAT('SELECT GETUTCDATE() AT TIME ZONE ''UTC'' AT TIME ZONE ''', @CurrentTimeZone, '''');
    END
    ELSE
    BEGIN
        INSERT INTO @Results
        (
            SourceTimeZone,
            SourceTime,
            TargetTimeZone,
            TargetTime,
            SelectQuery
        )
        SELECT @CurrentTimeZone,
               GETDATE(),
               'UTC',
               GETDATE()AT TIME ZONE @CurrentTimeZone AT TIME ZONE 'UTC',
               CONCAT('SELECT GETDATE() AT TIME ZONE ''', @CurrentTimeZone, ''' AT TIME ZONE ''UTC''');
    END

    FETCH NEXT FROM TimeZoneCursor
    INTO @CurrentTimeZone;
END

CLOSE TimeZoneCursor;

DEALLOCATE TimeZoneCursor;

SELECT *
FROM @Results
SourceTimeZoneSourceTimeTargetTimeZoneTargetTimeSelectQuery
Dateline Standard Time2023-08-18 21:57:20.480UTC2023-08-19 09:57:20.4800000 +00:00SELECT GETDATE() AT TIME ZONE 'Dateline Standard Time' AT TIME ZONE 'UTC'
UTC-112023-08-18 21:57:20.480UTC2023-08-19 08:57:20.4800000 +00:00SELECT GETDATE() AT TIME ZONE 'UTC-11' AT TIME ZONE 'UTC'
Aleutian Standard Time2023-08-18 21:57:20.483UTC2023-08-19 06:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Aleutian Standard Time' AT TIME ZONE 'UTC'
Hawaiian Standard Time2023-08-18 21:57:20.483UTC2023-08-19 07:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Hawaiian Standard Time' AT TIME ZONE 'UTC'
Marquesas Standard Time2023-08-18 21:57:20.483UTC2023-08-19 07:27:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Marquesas Standard Time' AT TIME ZONE 'UTC'
Alaskan Standard Time2023-08-18 21:57:20.483UTC2023-08-19 05:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Alaskan Standard Time' AT TIME ZONE 'UTC'
UTC-092023-08-18 21:57:20.483UTC2023-08-19 06:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'UTC-09' AT TIME ZONE 'UTC'
Pacific Standard Time (Mexico)2023-08-18 21:57:20.483UTC2023-08-19 04:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Pacific Standard Time (Mexico)' AT TIME ZONE 'UTC'
UTC-082023-08-18 21:57:20.483UTC2023-08-19 05:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'UTC-08' AT TIME ZONE 'UTC'
Pacific Standard Time2023-08-18 21:57:20.483UTC2023-08-19 04:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Pacific Standard Time' AT TIME ZONE 'UTC'
US Mountain Standard Time2023-08-18 21:57:20.483UTC2023-08-19 04:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'US Mountain Standard Time' AT TIME ZONE 'UTC'
Mountain Standard Time (Mexico)2023-08-18 21:57:20.483UTC2023-08-19 04:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Mountain Standard Time (Mexico)' AT TIME ZONE 'UTC'
Mountain Standard Time2023-08-18 21:57:20.483UTC2023-08-19 03:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Mountain Standard Time' AT TIME ZONE 'UTC'
Yukon Standard Time2023-08-18 21:57:20.483UTC2023-08-19 04:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Yukon Standard Time' AT TIME ZONE 'UTC'
Central America Standard Time2023-08-18 21:57:20.483UTC2023-08-19 03:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Central America Standard Time' AT TIME ZONE 'UTC'
Central Standard Time2023-08-18 21:57:20.483UTC2023-08-19 02:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Central Standard Time' AT TIME ZONE 'UTC'
Easter Island Standard Time2023-08-18 21:57:20.483UTC2023-08-19 03:57:20.4830000 +00:00SELECT GETDATE() AT TIME ZONE 'Easter Island Standard Time' AT TIME ZONE 'UTC'
Central Standard Time (Mexico)2023-08-18 21:57:20.487UTC2023-08-19 03:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Central Standard Time (Mexico)' AT TIME ZONE 'UTC'
Canada Central Standard Time2023-08-18 21:57:20.487UTC2023-08-19 03:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Canada Central Standard Time' AT TIME ZONE 'UTC'
SA Pacific Standard Time2023-08-18 21:57:20.487UTC2023-08-19 02:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'SA Pacific Standard Time' AT TIME ZONE 'UTC'
Eastern Standard Time (Mexico)2023-08-18 21:57:20.487UTC2023-08-19 02:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Eastern Standard Time (Mexico)' AT TIME ZONE 'UTC'
Eastern Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Eastern Standard Time' AT TIME ZONE 'UTC'
Haiti Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Haiti Standard Time' AT TIME ZONE 'UTC'
Cuba Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Cuba Standard Time' AT TIME ZONE 'UTC'
US Eastern Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'US Eastern Standard Time' AT TIME ZONE 'UTC'
Turks And Caicos Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Turks And Caicos Standard Time' AT TIME ZONE 'UTC'
Paraguay Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Paraguay Standard Time' AT TIME ZONE 'UTC'
Atlantic Standard Time2023-08-18 21:57:20.487UTC2023-08-19 00:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Atlantic Standard Time' AT TIME ZONE 'UTC'
Venezuela Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Venezuela Standard Time' AT TIME ZONE 'UTC'
Central Brazilian Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Central Brazilian Standard Time' AT TIME ZONE 'UTC'
SA Western Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'SA Western Standard Time' AT TIME ZONE 'UTC'
Pacific SA Standard Time2023-08-18 21:57:20.487UTC2023-08-19 01:57:20.4870000 +00:00SELECT GETDATE() AT TIME ZONE 'Pacific SA Standard Time' AT TIME ZONE 'UTC'
Newfoundland Standard Time2023-08-18 21:57:20.490UTC2023-08-19 00:27:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Newfoundland Standard Time' AT TIME ZONE 'UTC'
Tocantins Standard Time2023-08-18 21:57:20.490UTC2023-08-19 00:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Tocantins Standard Time' AT TIME ZONE 'UTC'
E. South America Standard Time2023-08-18 21:57:20.490UTC2023-08-19 00:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'E. South America Standard Time' AT TIME ZONE 'UTC'
SA Eastern Standard Time2023-08-18 21:57:20.490UTC2023-08-19 00:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'SA Eastern Standard Time' AT TIME ZONE 'UTC'
Argentina Standard Time2023-08-18 21:57:20.490UTC2023-08-19 00:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Argentina Standard Time' AT TIME ZONE 'UTC'
Greenland Standard Time2023-08-18 21:57:20.490UTC2023-08-18 23:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Greenland Standard Time' AT TIME ZONE 'UTC'
Montevideo Standard Time2023-08-18 21:57:20.490UTC2023-08-19 00:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Montevideo Standard Time' AT TIME ZONE 'UTC'
Magallanes Standard Time2023-08-18 21:57:20.490UTC2023-08-19 00:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Magallanes Standard Time' AT TIME ZONE 'UTC'
Saint Pierre Standard Time2023-08-18 21:57:20.490UTC2023-08-18 23:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Saint Pierre Standard Time' AT TIME ZONE 'UTC'
Bahia Standard Time2023-08-18 21:57:20.490UTC2023-08-19 00:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Bahia Standard Time' AT TIME ZONE 'UTC'
UTC-022023-08-18 21:57:20.490UTC2023-08-18 23:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'UTC-02' AT TIME ZONE 'UTC'
Mid-Atlantic Standard Time2023-08-18 21:57:20.490UTC2023-08-18 22:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Mid-Atlantic Standard Time' AT TIME ZONE 'UTC'
Azores Standard Time2023-08-18 21:57:20.490UTC2023-08-18 21:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Azores Standard Time' AT TIME ZONE 'UTC'
Cape Verde Standard Time2023-08-18 21:57:20.490UTC2023-08-18 22:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Cape Verde Standard Time' AT TIME ZONE 'UTC'
UTC2023-08-18 21:57:20.490UTC2023-08-18 21:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'UTC'
GMT Standard Time2023-08-18 21:57:20.490UTC2023-08-18 20:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'GMT Standard Time' AT TIME ZONE 'UTC'
Greenwich Standard Time2023-08-18 21:57:20.490UTC2023-08-18 21:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Greenwich Standard Time' AT TIME ZONE 'UTC'
Sao Tome Standard Time2023-08-18 21:57:20.490UTC2023-08-18 21:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Sao Tome Standard Time' AT TIME ZONE 'UTC'
Morocco Standard Time2023-08-18 21:57:20.490UTC2023-08-18 20:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Morocco Standard Time' AT TIME ZONE 'UTC'
W. Europe Standard Time2023-08-18 21:57:20.490UTC2023-08-18 19:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'W. Europe Standard Time' AT TIME ZONE 'UTC'
Central Europe Standard Time2023-08-18 21:57:20.490UTC2023-08-18 19:57:20.4900000 +00:00SELECT GETDATE() AT TIME ZONE 'Central Europe Standard Time' AT TIME ZONE 'UTC'
Romance Standard Time2023-08-18 21:57:20.493UTC2023-08-18 19:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'Romance Standard Time' AT TIME ZONE 'UTC'
Central European Standard Time2023-08-18 21:57:20.493UTC2023-08-18 19:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'Central European Standard Time' AT TIME ZONE 'UTC'
W. Central Africa Standard Time2023-08-18 21:57:20.493UTC2023-08-18 20:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'W. Central Africa Standard Time' AT TIME ZONE 'UTC'
GTB Standard Time2023-08-18 21:57:20.493UTC2023-08-18 18:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'GTB Standard Time' AT TIME ZONE 'UTC'
Middle East Standard Time2023-08-18 21:57:20.493UTC2023-08-18 18:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'Middle East Standard Time' AT TIME ZONE 'UTC'
Egypt Standard Time2023-08-18 21:57:20.493UTC2023-08-18 18:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'Egypt Standard Time' AT TIME ZONE 'UTC'
E. Europe Standard Time2023-08-18 21:57:20.493UTC2023-08-18 18:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'E. Europe Standard Time' AT TIME ZONE 'UTC'
Syria Standard Time2023-08-18 21:57:20.493UTC2023-08-18 18:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'Syria Standard Time' AT TIME ZONE 'UTC'
West Bank Standard Time2023-08-18 21:57:20.493UTC2023-08-18 18:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'West Bank Standard Time' AT TIME ZONE 'UTC'
South Africa Standard Time2023-08-18 21:57:20.493UTC2023-08-18 19:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'South Africa Standard Time' AT TIME ZONE 'UTC'
FLE Standard Time2023-08-18 21:57:20.493UTC2023-08-18 18:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'FLE Standard Time' AT TIME ZONE 'UTC'
Israel Standard Time2023-08-18 21:57:20.493UTC2023-08-18 18:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'Israel Standard Time' AT TIME ZONE 'UTC'
South Sudan Standard Time2023-08-18 21:57:20.493UTC2023-08-18 19:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'South Sudan Standard Time' AT TIME ZONE 'UTC'
Kaliningrad Standard Time2023-08-18 21:57:20.493UTC2023-08-18 19:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'Kaliningrad Standard Time' AT TIME ZONE 'UTC'
Sudan Standard Time2023-08-18 21:57:20.493UTC2023-08-18 19:57:20.4930000 +00:00SELECT GETDATE() AT TIME ZONE 'Sudan Standard Time' AT TIME ZONE 'UTC'
Libya Standard Time2023-08-18 21:57:20.497UTC2023-08-18 19:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Libya Standard Time' AT TIME ZONE 'UTC'
Namibia Standard Time2023-08-18 21:57:20.497UTC2023-08-18 19:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Namibia Standard Time' AT TIME ZONE 'UTC'
Jordan Standard Time2023-08-18 21:57:20.497UTC2023-08-18 18:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Jordan Standard Time' AT TIME ZONE 'UTC'
Arabic Standard Time2023-08-18 21:57:20.497UTC2023-08-18 18:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Arabic Standard Time' AT TIME ZONE 'UTC'
Turkey Standard Time2023-08-18 21:57:20.497UTC2023-08-18 18:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Turkey Standard Time' AT TIME ZONE 'UTC'
Arab Standard Time2023-08-18 21:57:20.497UTC2023-08-18 18:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Arab Standard Time' AT TIME ZONE 'UTC'
Belarus Standard Time2023-08-18 21:57:20.497UTC2023-08-18 18:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Belarus Standard Time' AT TIME ZONE 'UTC'
Russian Standard Time2023-08-18 21:57:20.497UTC2023-08-18 18:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Russian Standard Time' AT TIME ZONE 'UTC'
E. Africa Standard Time2023-08-18 21:57:20.497UTC2023-08-18 18:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'E. Africa Standard Time' AT TIME ZONE 'UTC'
Volgograd Standard Time2023-08-18 21:57:20.497UTC2023-08-18 18:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Volgograd Standard Time' AT TIME ZONE 'UTC'
Iran Standard Time2023-08-18 21:57:20.497UTC2023-08-18 18:27:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Iran Standard Time' AT TIME ZONE 'UTC'
Arabian Standard Time2023-08-18 21:57:20.497UTC2023-08-18 17:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Arabian Standard Time' AT TIME ZONE 'UTC'
Astrakhan Standard Time2023-08-18 21:57:20.497UTC2023-08-18 17:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Astrakhan Standard Time' AT TIME ZONE 'UTC'
Azerbaijan Standard Time2023-08-18 21:57:20.497UTC2023-08-18 17:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Azerbaijan Standard Time' AT TIME ZONE 'UTC'
Russia Time Zone 32023-08-18 21:57:20.497UTC2023-08-18 17:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Russia Time Zone 3' AT TIME ZONE 'UTC'
Mauritius Standard Time2023-08-18 21:57:20.497UTC2023-08-18 17:57:20.4970000 +00:00SELECT GETDATE() AT TIME ZONE 'Mauritius Standard Time' AT TIME ZONE 'UTC'
Saratov Standard Time2023-08-18 21:57:20.500UTC2023-08-18 17:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Saratov Standard Time' AT TIME ZONE 'UTC'
Georgian Standard Time2023-08-18 21:57:20.500UTC2023-08-18 17:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Georgian Standard Time' AT TIME ZONE 'UTC'
Caucasus Standard Time2023-08-18 21:57:20.500UTC2023-08-18 17:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Caucasus Standard Time' AT TIME ZONE 'UTC'
Afghanistan Standard Time2023-08-18 21:57:20.500UTC2023-08-18 17:27:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Afghanistan Standard Time' AT TIME ZONE 'UTC'
West Asia Standard Time2023-08-18 21:57:20.500UTC2023-08-18 16:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'West Asia Standard Time' AT TIME ZONE 'UTC'
Ekaterinburg Standard Time2023-08-18 21:57:20.500UTC2023-08-18 16:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Ekaterinburg Standard Time' AT TIME ZONE 'UTC'
Pakistan Standard Time2023-08-18 21:57:20.500UTC2023-08-18 16:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Pakistan Standard Time' AT TIME ZONE 'UTC'
Qyzylorda Standard Time2023-08-18 21:57:20.500UTC2023-08-18 16:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Qyzylorda Standard Time' AT TIME ZONE 'UTC'
India Standard Time2023-08-18 21:57:20.500UTC2023-08-18 16:27:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'India Standard Time' AT TIME ZONE 'UTC'
Sri Lanka Standard Time2023-08-18 21:57:20.500UTC2023-08-18 16:27:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Sri Lanka Standard Time' AT TIME ZONE 'UTC'
Nepal Standard Time2023-08-18 21:57:20.500UTC2023-08-18 16:12:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Nepal Standard Time' AT TIME ZONE 'UTC'
Central Asia Standard Time2023-08-18 21:57:20.500UTC2023-08-18 15:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Central Asia Standard Time' AT TIME ZONE 'UTC'
Bangladesh Standard Time2023-08-18 21:57:20.500UTC2023-08-18 15:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Bangladesh Standard Time' AT TIME ZONE 'UTC'
Omsk Standard Time2023-08-18 21:57:20.500UTC2023-08-18 15:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Omsk Standard Time' AT TIME ZONE 'UTC'
Myanmar Standard Time2023-08-18 21:57:20.500UTC2023-08-18 15:27:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Myanmar Standard Time' AT TIME ZONE 'UTC'
SE Asia Standard Time2023-08-18 21:57:20.500UTC2023-08-18 14:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'SE Asia Standard Time' AT TIME ZONE 'UTC'
Altai Standard Time2023-08-18 21:57:20.500UTC2023-08-18 14:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Altai Standard Time' AT TIME ZONE 'UTC'
W. Mongolia Standard Time2023-08-18 21:57:20.500UTC2023-08-18 14:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'W. Mongolia Standard Time' AT TIME ZONE 'UTC'
North Asia Standard Time2023-08-18 21:57:20.500UTC2023-08-18 14:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'North Asia Standard Time' AT TIME ZONE 'UTC'
N. Central Asia Standard Time2023-08-18 21:57:20.500UTC2023-08-18 14:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'N. Central Asia Standard Time' AT TIME ZONE 'UTC'
Tomsk Standard Time2023-08-18 21:57:20.500UTC2023-08-18 14:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'Tomsk Standard Time' AT TIME ZONE 'UTC'
China Standard Time2023-08-18 21:57:20.500UTC2023-08-18 13:57:20.5000000 +00:00SELECT GETDATE() AT TIME ZONE 'China Standard Time' AT TIME ZONE 'UTC'
North Asia East Standard Time2023-08-18 21:57:20.503UTC2023-08-18 13:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'North Asia East Standard Time' AT TIME ZONE 'UTC'
Singapore Standard Time2023-08-18 21:57:20.503UTC2023-08-18 13:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'Singapore Standard Time' AT TIME ZONE 'UTC'
W. Australia Standard Time2023-08-18 21:57:20.503UTC2023-08-18 13:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'W. Australia Standard Time' AT TIME ZONE 'UTC'
Taipei Standard Time2023-08-18 21:57:20.503UTC2023-08-18 13:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'Taipei Standard Time' AT TIME ZONE 'UTC'
Ulaanbaatar Standard Time2023-08-18 21:57:20.503UTC2023-08-18 13:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'Ulaanbaatar Standard Time' AT TIME ZONE 'UTC'
Aus Central W. Standard Time2023-08-18 21:57:20.503UTC2023-08-18 13:12:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'Aus Central W. Standard Time' AT TIME ZONE 'UTC'
Transbaikal Standard Time2023-08-18 21:57:20.503UTC2023-08-18 12:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'Transbaikal Standard Time' AT TIME ZONE 'UTC'
Tokyo Standard Time2023-08-18 21:57:20.503UTC2023-08-18 12:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'Tokyo Standard Time' AT TIME ZONE 'UTC'
North Korea Standard Time2023-08-18 21:57:20.503UTC2023-08-18 12:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'North Korea Standard Time' AT TIME ZONE 'UTC'
Korea Standard Time2023-08-18 21:57:20.503UTC2023-08-18 12:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'Korea Standard Time' AT TIME ZONE 'UTC'
Yakutsk Standard Time2023-08-18 21:57:20.503UTC2023-08-18 12:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'Yakutsk Standard Time' AT TIME ZONE 'UTC'
Cen. Australia Standard Time2023-08-18 21:57:20.503UTC2023-08-18 12:27:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'Cen. Australia Standard Time' AT TIME ZONE 'UTC'
AUS Central Standard Time2023-08-18 21:57:20.503UTC2023-08-18 12:27:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'AUS Central Standard Time' AT TIME ZONE 'UTC'
E. Australia Standard Time2023-08-18 21:57:20.503UTC2023-08-18 11:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'E. Australia Standard Time' AT TIME ZONE 'UTC'
AUS Eastern Standard Time2023-08-18 21:57:20.503UTC2023-08-18 11:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'AUS Eastern Standard Time' AT TIME ZONE 'UTC'
West Pacific Standard Time2023-08-18 21:57:20.503UTC2023-08-18 11:57:20.5030000 +00:00SELECT GETDATE() AT TIME ZONE 'West Pacific Standard Time' AT TIME ZONE 'UTC'
Tasmania Standard Time2023-08-18 21:57:20.507UTC2023-08-18 11:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Tasmania Standard Time' AT TIME ZONE 'UTC'
Vladivostok Standard Time2023-08-18 21:57:20.507UTC2023-08-18 11:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Vladivostok Standard Time' AT TIME ZONE 'UTC'
Lord Howe Standard Time2023-08-18 21:57:20.507UTC2023-08-18 11:27:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Lord Howe Standard Time' AT TIME ZONE 'UTC'
Bougainville Standard Time2023-08-18 21:57:20.507UTC2023-08-18 10:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Bougainville Standard Time' AT TIME ZONE 'UTC'
Russia Time Zone 102023-08-18 21:57:20.507UTC2023-08-18 10:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Russia Time Zone 10' AT TIME ZONE 'UTC'
Magadan Standard Time2023-08-18 21:57:20.507UTC2023-08-18 10:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Magadan Standard Time' AT TIME ZONE 'UTC'
Norfolk Standard Time2023-08-18 21:57:20.507UTC2023-08-18 10:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Norfolk Standard Time' AT TIME ZONE 'UTC'
Sakhalin Standard Time2023-08-18 21:57:20.507UTC2023-08-18 10:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Sakhalin Standard Time' AT TIME ZONE 'UTC'
Central Pacific Standard Time2023-08-18 21:57:20.507UTC2023-08-18 10:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Central Pacific Standard Time' AT TIME ZONE 'UTC'
Russia Time Zone 112023-08-18 21:57:20.507UTC2023-08-18 09:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Russia Time Zone 11' AT TIME ZONE 'UTC'
New Zealand Standard Time2023-08-18 21:57:20.507UTC2023-08-18 09:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'New Zealand Standard Time' AT TIME ZONE 'UTC'
UTC+122023-08-18 21:57:20.507UTC2023-08-18 09:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'UTC+12' AT TIME ZONE 'UTC'
Fiji Standard Time2023-08-18 21:57:20.507UTC2023-08-18 09:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Fiji Standard Time' AT TIME ZONE 'UTC'
Kamchatka Standard Time2023-08-18 21:57:20.507UTC2023-08-18 08:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Kamchatka Standard Time' AT TIME ZONE 'UTC'
Chatham Islands Standard Time2023-08-18 21:57:20.507UTC2023-08-18 09:12:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'Chatham Islands Standard Time' AT TIME ZONE 'UTC'
UTC+132023-08-18 21:57:20.507UTC2023-08-18 08:57:20.5070000 +00:00SELECT GETDATE() AT TIME ZONE 'UTC+13' AT TIME ZONE 'UTC'
Tonga Standard Time2023-08-18 21:57:20.510UTC2023-08-18 08:57:20.5100000 +00:00SELECT GETDATE() AT TIME ZONE 'Tonga Standard Time' AT TIME ZONE 'UTC'
Samoa Standard Time2023-08-18 21:57:20.510UTC2023-08-18 08:57:20.5100000 +00:00SELECT GETDATE() AT TIME ZONE 'Samoa Standard Time' AT TIME ZONE 'UTC'
Line Islands Standard Time2023-08-18 21:57:20.510UTC2023-08-18 07:57:20.5100000 +00:00SELECT GETDATE() AT TIME ZONE 'Line Islands Standard Time' AT TIME ZONE 'UTC'