search

dotnet / runtime

.NET is a cross-platform runtime for cloud, mobile, desktop, and IoT apps.
https://docs.microsoft.com/dotnet/core/
MIT License
15.27k stars 4.73k forks source link

Incorrect UTC offset in Samoa Standard Time ? #30601

Closed ststeiger closed 4 years ago

ststeiger commented 5 years ago

I was playing around with timezones. If I save the timezones to DB, I get the following from .NET: Samoa Standard Time => (UTC+13:00) Samoa

However, wikipedia lists Samoa Standard Time as UTC-11: Samoa Standard Time UTC-11

A quick check at timeanddate.com shows -11 as well.

Is this correct ? I mean +13 =24-11, but doesn't that result in a wrong date ?

The other 22 matches are identical.

public static void SaveTimeZonesToDb()
{
    System.Collections.ObjectModel.ReadOnlyCollection<System.TimeZoneInfo> tz;
    tz = System.TimeZoneInfo.GetSystemTimeZones();

    // https://en.wikipedia.org/wiki/List_of_military_time_zones
    // https://www.worldtimezone.com/wtz-map-military.html
    // https://en.wikipedia.org/wiki/List_of_time_offsets_by_U.S._state_and_territory
    // https://en.wikipedia.org/wiki/List_of_tz_database_time_zones
    // https://www.timeanddate.com/time/dateline.html

    using (System.Data.Common.DbConnection connection = DapperTest.GetOpenConnection(true))
    {
        for (int i = 0; i < tz.Count; ++i)
        {
            System.Console.WriteLine(tz[i].Id);
            System.Console.WriteLine(tz[i].StandardName);
            System.Console.WriteLine(tz[i].DaylightName);
            System.Console.WriteLine(tz[i].DisplayName);
            System.Console.WriteLine(tz[i].BaseUtcOffset.ToString());
            System.Console.WriteLine(tz[i].BaseUtcOffset.TotalMilliseconds); // double
            System.Console.WriteLine(tz[i].SupportsDaylightSavingTime); // bool

            System.Console.WriteLine(tz[i].GetAmbiguousTimeOffsets(System.DateTime.Now));

            // DapperTest.InsertTimezone(connection, tz[i]);
        }

    }

    // System.Console.WriteLine(tz[0].GetAmbiguousTimeOffsets(System.DateTime.Now));
    // System.Console.WriteLine(tz[0].GetUtcOffset(System.DateTime.Now));
    // System.Console.WriteLine(tz[0].IsAmbiguousTime(System.DateTime.Now));
    // System.Console.WriteLine(tz[0].IsDaylightSavingTime(System.DateTime.Now));
    // System.Console.WriteLine(tz[0].IsInvalidTime(System.DateTime.Now));

}
ststeiger commented 5 years ago 

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.T_SYS_Wikipedia_TimeZones') AND type in (N'U'))
BEGIN
CREATE TABLE dbo.T_SYS_Wikipedia_TimeZones
(
     Id int NOT NULL
    ,Abbrev national character varying(256) NULL
    ,TimeZoneName national character varying(256) NULL
    ,OffsetString national character varying(256) NULL
    ,Offset int NULL
    ,IsDST bit NULL
    ,WinterId int NULL
    ,Remarks national character varying(256) NULL
    ,CONSTRAINT PK_T_SYS_Wikipedia_TimeZones PRIMARY KEY( Id )
); 
END

GO


-- DELETE FROM T_SYS_Wikipedia_TimeZones;

IF NOT EXISTS(SELECT * FROM T_SYS_Wikipedia_TimeZones)
BEGIN 
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (1, N'ACDT', N'Australian Central Daylight Savings Time', N'UTC+10:30', 37800000, 1, 2, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (2, N'ACST', N'Australian Central Standard Time', N'UTC+09:30', 34200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (3, N'ACT', N'Acre Time', N'UTC-05', -18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (4, N'ACT', N'ASEAN Common Time', N'UTC+06:30 – UTC+09', NULL, 0, NULL, N'(unofficial)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (5, N'ACWST', N'Australian Central Western Standard Time', N'UTC+08:45', 31500000, 0, NULL, N'(unofficial)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (6, N'ADT', N'Atlantic Daylight Time', N'UTC-03', -10800000, 1, 20, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (7, N'AEDT', N'Australian Eastern Daylight Savings Time', N'UTC+11', 39600000, 1, 8, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (8, N'AEST', N'Australian Eastern Standard Time', N'UTC+10', 36000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (9, N'AFT', N'Afghanistan Time', N'UTC+04:30', 16200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (10, N'AKDT', N'Alaska Daylight Time', N'UTC-08', -28800000, 1, 11, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (11, N'AKST', N'Alaska Standard Time', N'UTC-09', -32400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (12, N'ALMT', N'Alma-Ata Time', N'UTC+06', 21600000, 0, NULL, N'[1]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (13, N'AMST', N'Amazon Summer Time', N'UTC-03', -10800000, 1, 13, N'(Brazil)[2]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (14, N'AMT', N'Amazon Time', N'UTC-04', -14400000, 0, NULL, N'(Brazil)[3]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (15, N'AMT', N'Armenia Time', N'UTC+04', 14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (16, N'ANAT', N'Anadyr Time', N'UTC+12', 43200000, 0, NULL, N'[4]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (17, N'AQTT', N'Aqtobe Time', N'UTC+05', 18000000, 0, NULL, N'[5]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (18, N'ART', N'Argentina Time', N'UTC-03', -10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (19, N'AST', N'Arabia Standard Time', N'UTC+03', 10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (20, N'AST', N'Atlantic Standard Time', N'UTC-04', -14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (21, N'AWST', N'Australian Western Standard Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (22, N'AZOST', N'Azores Summer Time', N'UTC+00', 0, 1, 23, N'UTC±00');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (23, N'AZOT', N'Azores Standard Time', N'UTC-01', -3600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (24, N'AZT', N'Azerbaijan Time', N'UTC+04', 14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (25, N'BDT', N'Brunei Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (26, N'BIOT', N'British Indian Ocean Time', N'UTC+06', 21600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (27, N'BIT', N'Baker Island Time', N'UTC-12', -43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (28, N'BOT', N'Bolivia Time', N'UTC-04', -14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (29, N'BRST', N'Brasília Summer Time', N'UTC-02', -7200000, 1, 30, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (30, N'BRT', N'Brasilia Time', N'UTC-03', -10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (31, N'BST', N'Bangladesh Standard Time', N'UTC+06', 21600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (32, N'BST', N'Bougainville Standard Time', N'UTC+11', 39600000, 0, NULL, N'[6]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (33, N'BST', N'British Summer Time', N'UTC+01', 3600000, 0, NULL, N'(British Standard Time from Feb 1968 to Oct 1971)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (34, N'BTT', N'Bhutan Time', N'UTC+06', 21600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (35, N'CAT', N'Central Africa Time', N'UTC+02', 7200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (36, N'CCT', N'Cocos Islands Time', N'UTC+06:30', 23400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (37, N'CDT', N'Central Daylight Time', N'UTC-05', -18000000, 1, 54, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (38, N'CDT', N'Cuba Daylight Time', N'UTC-04', -14400000, 1, 56, N'(North America)[7]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (39, N'CEST', N'Central European Summer Time', N'UTC+02', 7200000, 1, 40, N'(Cf. HAEC)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (40, N'CET', N'Central European Time', N'UTC+01', 3600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (41, N'CHADT', N'Chatham Daylight Time', N'UTC+13:45', 49500000, 1, 42, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (42, N'CHAST', N'Chatham Standard Time', N'UTC+12:45', 45900000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (43, N'CHOT', N'Choibalsan Standard Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (44, N'CHOST', N'Choibalsan Summer Time', N'UTC+09', 32400000, 1, 43, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (45, N'CHST', N'Chamorro Standard Time', N'UTC+10', 36000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (46, N'CHUT', N'Chuuk Time', N'UTC+10', 36000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (47, N'CIST', N'Clipperton Island Standard Time', N'UTC-08', -28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (48, N'CIT', N'Central Indonesia Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (49, N'CKT', N'Cook Island Time', N'UTC-10', -36000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (50, N'CLST', N'Chile Summer Time', N'UTC-03', -10800000, 1, 51, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (51, N'CLT', N'Chile Standard Time', N'UTC-04', -14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (52, N'COST', N'Colombia Summer Time', N'UTC-04', -14400000, 1, 53, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (53, N'COT', N'Colombia Time', N'UTC-05', -18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (54, N'CST', N'Central Standard Time', N'UTC-06', -21600000, 0, NULL, N'(North America)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (55, N'CST', N'China Standard Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (56, N'CST', N'Cuba Standard Time', N'UTC-05', -18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (57, N'CT', N'China Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (58, N'CVT', N'Cape Verde Time', N'UTC-01', -3600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (59, N'CWST', N'Central Western Standard Time', N'UTC+08:45', 31500000, 0, NULL, N'(Australia) unofficial');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (60, N'CXT', N'Christmas Island Time', N'UTC+07', 25200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (61, N'DAVT', N'Davis Time', N'UTC+07', 25200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (62, N'DDUT', N'Dumont d''Urville Time', N'UTC+10', 36000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (63, N'DFT', N'AIX-specific equivalent of Central European Time', N'UTC+01', 3600000, 0, NULL, N'[NB 1]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (64, N'EASST', N'Easter Island Summer Time', N'UTC-05', -18000000, 1, 65, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (65, N'EAST', N'Easter Island Standard Time', N'UTC-06', -21600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (66, N'EAT', N'East Africa Time', N'UTC+03', 10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (67, N'ECT', N'Eastern Caribbean Time', N'UTC-04', -14400000, 0, NULL, N'(does not recognise DST)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (68, N'ECT', N'Ecuador Time', N'UTC-05', -18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (69, N'EDT', N'Eastern Daylight Time', N'UTC-04', -14400000, 1, 75, N'(North America)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (70, N'EEST', N'Eastern European Summer Time', N'UTC+03', 10800000, 1, 71, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (71, N'EET', N'Eastern European Time', N'UTC+02', 7200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (72, N'EGST', N'Eastern Greenland Summer Time', N'UTC+00', 0, 1, 73, N'UTC±00');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (73, N'EGT', N'Eastern Greenland Time', N'UTC-01', -3600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (74, N'EIT', N'Eastern Indonesian Time', N'UTC+09', 32400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (75, N'EST', N'Eastern Standard Time', N'UTC-05', -18000000, 0, NULL, N'(North America)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (76, N'FET', N'Further-eastern European Time', N'UTC+03', 10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (77, N'FJT', N'Fiji Time', N'UTC+12', 43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (78, N'FKST', N'Falkland Islands Summer Time', N'UTC-03', -10800000, 1, 79, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (79, N'FKT', N'Falkland Islands Time', N'UTC-04', -14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (80, N'FNT', N'Fernando de Noronha Time', N'UTC-02', -7200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (81, N'GALT', N'Galápagos Time', N'UTC-06', -21600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (82, N'GAMT', N'Gambier Islands Time', N'UTC-09', -32400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (83, N'GET', N'Georgia Standard Time', N'UTC+04', 14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (84, N'GFT', N'French Guiana Time', N'UTC-03', -10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (85, N'GILT', N'Gilbert Island Time', N'UTC+12', 43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (86, N'GIT', N'Gambier Island Time', N'UTC-09', -32400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (87, N'GMT', N'Greenwich Mean Time', N'UTC+00', 0, 0, NULL, N'UTC±00');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (88, N'GST', N'South Georgia and the South Sandwich Islands Time', N'UTC-02', -7200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (89, N'GST', N'Gulf Standard Time', N'UTC+04', 14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (90, N'GYT', N'Guyana Time', N'UTC-04', -14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (91, N'HDT', N'Hawaii–Aleutian Daylight Time', N'UTC-09', -32400000, 1, 93, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (92, N'HAEC', N'Heure Avancée d''Europe Centrale', N'UTC+02', 7200000, 0, NULL, N'French-language name for CEST');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (93, N'HST', N'Hawaii–Aleutian Standard Time', N'UTC-10', -36000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (94, N'HKT', N'Hong Kong Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (95, N'HMT', N'Heard and McDonald Islands Time', N'UTC+05', 18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (96, N'HOVST', N'Hovd Summer Time', N'UTC+08', 28800000, 1, 97, N'(*not used from 2017-present)*');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (97, N'HOVT', N'Hovd Time', N'UTC+07', 25200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (98, N'ICT', N'Indochina Time', N'UTC+07', 25200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (99, N'IDLW', N'International Day Line West time zone', N'UTC-12', -43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (100, N'IDT', N'Israel Daylight Time', N'UTC+03', 10800000, 1, 107, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (101, N'IOT', N'Indian Ocean Time', N'UTC+03', 10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (102, N'IRDT', N'Iran Daylight Time', N'UTC+04:30', 16200000, 1, 104, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (103, N'IRKT', N'Irkutsk Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (104, N'IRST', N'Iran Standard Time', N'UTC+03:30', 12600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (105, N'IST', N'Indian Standard Time', N'UTC+05:30', 19800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (106, N'IST', N'Irish Standard Time', N'UTC+01', 3600000, 0, NULL, N'[8]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (107, N'IST', N'Israel Standard Time', N'UTC+02', 7200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (108, N'JST', N'Japan Standard Time', N'UTC+09', 32400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (109, N'KALT', N'Kaliningrad Time', N'UTC+02', 7200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (110, N'KGT', N'Kyrgyzstan Time', N'UTC+06', 21600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (111, N'KOST', N'Kosrae Time', N'UTC+11', 39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (112, N'KRAT', N'Krasnoyarsk Time', N'UTC+07', 25200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (113, N'KST', N'Korea Standard Time', N'UTC+09', 32400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (114, N'LHST', N'Lord Howe Standard Time', N'UTC+10:30', 37800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (115, N'LHST', N'Lord Howe Summer Time', N'UTC+11', 39600000, 1, 114, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (116, N'LINT', N'Line Islands Time', N'UTC+14', 50400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (117, N'MAGT', N'Magadan Time', N'UTC+12', 43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (118, N'MART', N'Marquesas Islands Time', N'UTC-09:30', -34200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (119, N'MAWT', N'Mawson Station Time', N'UTC+05', 18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (120, N'MDT', N'Mountain Daylight Time', N'UTC-06', -21600000, 1, 129, N'(North America)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (121, N'MET', N'Middle European Time', N'UTC+01', 3600000, 0, NULL, N'Same zone as CET');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (122, N'MEST', N'Middle European Summer Time', N'UTC+02', 7200000, 1, 121, N'Same zone as CEST');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (123, N'MHT', N'Marshall Islands Time', N'UTC+12', 43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (124, N'MIST', N'Macquarie Island Station Time', N'UTC+11', 39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (125, N'MIT', N'Marquesas Islands Time', N'UTC-09:30', -34200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (126, N'MMT', N'Myanmar Standard Time', N'UTC+06:30', 23400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (127, N'MSK', N'Moscow Time', N'UTC+03', 10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (128, N'MST', N'Malaysia Standard Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (129, N'MST', N'Mountain Standard Time', N'UTC-07', -25200000, 0, NULL, N'(North America)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (130, N'MUT', N'Mauritius Time', N'UTC+04', 14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (131, N'MVT', N'Maldives Time', N'UTC+05', 18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (132, N'MYT', N'Malaysia Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (133, N'NCT', N'New Caledonia Time', N'UTC+11', 39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (134, N'NDT', N'Newfoundland Daylight Time', N'UTC-02:30', -9000000, 1, 138, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (135, N'NFT', N'Norfolk Island Time', N'UTC+11', 39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (136, N'NOVT', N'Novosibirsk Time', N'UTC+07', 25200000, 0, NULL, N'[9]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (137, N'NPT', N'Nepal Time', N'UTC+05:45', 20700000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (138, N'NST', N'Newfoundland Standard Time', N'UTC-03:30', -12600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (139, N'NT', N'Newfoundland Time', N'UTC-03:30', -12600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (140, N'NUT', N'Niue Time', N'UTC-11', -39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (141, N'NZDT', N'New Zealand Daylight Time', N'UTC+13', 46800000, 1, 142, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (142, N'NZST', N'New Zealand Standard Time', N'UTC+12', 43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (143, N'OMST', N'Omsk Time', N'UTC+06', 21600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (144, N'ORAT', N'Oral Time', N'UTC+05', 18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (145, N'PDT', N'Pacific Daylight Time', N'UTC-07', -25200000, 1, 155, N'(North America)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (146, N'PET', N'Peru Time', N'UTC-05', -18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (147, N'PETT', N'Kamchatka Time', N'UTC+12', 43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (148, N'PGT', N'Papua New Guinea Time', N'UTC+10', 36000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (149, N'PHOT', N'Phoenix Island Time', N'UTC+13', 46800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (150, N'PHT', N'Philippine Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (151, N'PKT', N'Pakistan Standard Time', N'UTC+05', 18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (152, N'PMDT', N'Saint Pierre and Miquelon Daylight Time', N'UTC-02', -7200000, 1, 153, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (153, N'PMST', N'Saint Pierre and Miquelon Standard Time', N'UTC-03', -10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (154, N'PONT', N'Pohnpei Standard Time', N'UTC+11', 39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (155, N'PST', N'Pacific Standard Time', N'UTC-08', -28800000, 0, NULL, N'(North America)');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (156, N'PST', N'Philippine Standard Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (157, N'PYST', N'Paraguay Summer Time', N'UTC-03', -10800000, 1, 158, N'[10]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (158, N'PYT', N'Paraguay Time', N'UTC-04', -14400000, 0, NULL, N'[11]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (159, N'RET', N'Réunion Time', N'UTC+04', 14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (160, N'ROTT', N'Rothera Research Station Time', N'UTC-03', -10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (161, N'SAKT', N'Sakhalin Island Time', N'UTC+11', 39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (162, N'SAMT', N'Samara Time', N'UTC+04', 14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (163, N'SAST', N'South African Standard Time', N'UTC+02', 7200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (164, N'SBT', N'Solomon Islands Time', N'UTC+11', 39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (165, N'SCT', N'Seychelles Time', N'UTC+04', 14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (166, N'SDT', N'Samoa Daylight Time', N'UTC-10', -36000000, 1, 171, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (167, N'SGT', N'Singapore Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (168, N'SLST', N'Sri Lanka Standard Time', N'UTC+05:30', 19800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (169, N'SRET', N'Srednekolymsk Time', N'UTC+11', 39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (170, N'SRT', N'Suriname Time', N'UTC-03', -10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (171, N'SST', N'Samoa Standard Time', N'UTC-11', -39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (172, N'SST', N'Singapore Standard Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (173, N'SYOT', N'Showa Station Time', N'UTC+03', 10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (174, N'TAHT', N'Tahiti Time', N'UTC-10', -36000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (175, N'THA', N'Thailand Standard Time', N'UTC+07', 25200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (176, N'TFT', N'French Southern and Antarctic Time', N'UTC+05', 18000000, 0, NULL, N'[12]');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (177, N'TJT', N'Tajikistan Time', N'UTC+05', 18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (178, N'TKT', N'Tokelau Time', N'UTC+13', 46800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (179, N'TLT', N'Timor Leste Time', N'UTC+09', 32400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (180, N'TMT', N'Turkmenistan Time', N'UTC+05', 18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (181, N'TRT', N'Turkey Time', N'UTC+03', 10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (182, N'TOT', N'Tonga Time', N'UTC+13', 46800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (183, N'TVT', N'Tuvalu Time', N'UTC+12', 43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (184, N'ULAST', N'Ulaanbaatar Summer Time', N'UTC+09', 32400000, 1, 185, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (185, N'ULAT', N'Ulaanbaatar Standard Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (186, N'UTC', N'Coordinated Universal Time', N'UTC+00', 0, 0, NULL, N'UTC±00');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (187, N'UYST', N'Uruguay Summer Time', N'UTC-02', -7200000, 1, 188, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (188, N'UYT', N'Uruguay Standard Time', N'UTC-03', -10800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (189, N'UZT', N'Uzbekistan Time', N'UTC+05', 18000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (190, N'VET', N'Venezuelan Standard Time', N'UTC-04', -14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (191, N'VLAT', N'Vladivostok Time', N'UTC+10', 36000000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (192, N'VOLT', N'Volgograd Time', N'UTC+04', 14400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (193, N'VOST', N'Vostok Station Time', N'UTC+06', 21600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (194, N'VUT', N'Vanuatu Time', N'UTC+11', 39600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (195, N'WAKT', N'Wake Island Time', N'UTC+12', 43200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (196, N'WAST', N'West Africa Summer Time', N'UTC+02', 7200000, 1, 197, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (197, N'WAT', N'West Africa Time', N'UTC+01', 3600000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (198, N'WEST', N'Western European Summer Time', N'UTC+01', 3600000, 1, 199, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (199, N'WET', N'Western European Time', N'UTC+00', 0, 0, NULL, N'UTC±00');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (200, N'WIT', N'Western Indonesian Time', N'UTC+07', 25200000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (201, N'WST', N'Western Standard Time', N'UTC+08', 28800000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (202, N'YAKT', N'Yakutsk Time', N'UTC+09', 32400000, 0, NULL, N'');
    INSERT INTO T_SYS_Wikipedia_TimeZones (Id, Abbrev, TimeZoneName, OffsetString, Offset, IsDST, WinterId, Remarks) VALUES (203, N'YEKT', N'Yekaterinburg Time', N'UTC+05', 18000000, 0, NULL, N'');
END
svick commented 5 years ago

I believe the problem here is that "Samoa Standard Time" is not an official name, so Wikipedia and Windows disagree about which timezone to use that name for.

The two relevant timezones are:

Region UTC offset Wikipedia article tzdb name Windows name
Samoa +13 Time in Samoa Pacific/Apia Samoa Standard Time
American Samoa -11 Samoa Time Zone Pacific/Pago_Pago UTC-11 (?)

So I don't think there's anything actually wrong here. (Except maybe that Wikipedia shouldn't call the timezone used in American Samoa "Samoa Standard Time".)

ststeiger commented 5 years ago

Interesting, ambiguous id.