Does .NET have the history of time zone changes?

by

.NET tracks some history, but it is not always accurate. You’ve stumbled upon one of the inaccuracies.

.NET imports all of it’s time zone information from Windows via the registry, as described here and here. If you look in the registry at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones\Russian Standard Time\Dynamic DST you’ll find that it only tracks information from 2010 forward for this time zone. Testing dates in year 2000 is not going to work well, as it will fall back to the earliest rule available (2010).

Base UTC offset information is tracked in the registry, but not in the AdjustmentRule class that .NET imports it into. If you check the adjustment rules for this time zone, you’ll find that 2012 and 2013 are not imported at all:

var tz = TimeZoneInfo.FindSystemTimeZoneById("Russian Standard Time");
foreach (var rule in tz.GetAdjustmentRules())
{
    Console.WriteLine("{0:d} - {1:d}", rule.DateStart, rule.DateEnd);
}

OUTPUT:

1/1/0001 - 12/31/2010
1/1/2011 - 12/31/2011
1/1/2014 - 12/31/2014

Even though they exist in the Windows registry, 2012 and 2013 are not imported because they have no daylight saving time adjustments.

This creates a problem when the base offset changes – like it has for this time zone. Since it is currently +3, and the two year where it was +4 were not imported, then it will look like it was +3 for those missing years.

There is no good solution for this using TimeZoneInfo. Even if you try to create your own custom time zones, you’ll have trouble fitting this kind of change into the data structures available.

Fortunately, there is another option. You can use standard IANA time zones, via the Noda Time library.

The following code uses Noda Time to match what you wrote in your original code:

DateTimeZone tz = DateTimeZoneProviders.Tzdb.GetSystemDefault();
Console.WriteLine(Instant.FromUtc(2012, 1, 1, 0, 0).InZone(tz).LocalDateTime);
Console.WriteLine(Instant.FromUtc(2012, 6, 1, 0, 0).InZone(tz).LocalDateTime);
Console.WriteLine(Instant.FromUtc(2000, 1, 1, 0, 0).InZone(tz).LocalDateTime);
Console.WriteLine(Instant.FromUtc(2000, 6, 1, 0, 0).InZone(tz).LocalDateTime);

If your local time zone is not already set for Moscow, you can change the first line to:

DateTimeZone tz = DateTimeZoneProviders.Tzdb["Europe/Moscow"];

OUTPUT:

1/1/2012 4:00:00 AM
6/1/2012 4:00:00 AM
1/1/2000 3:00:00 AM
6/1/2000 4:00:00 AM

Update

The problem described above of AdjustmentRule not tracking base offset changes was described in Microsoft Support article KB3012229, and subsequently fixed in .NET Framework 4.6 and also in .NET Core.

In the reference sources, one can see that AdjustmentRule now keeps a m_baseUtcOffsetDelta field. While this field is not exposed via a public property, it does factor in to the calculations, and it does reflect in serialization if you use the FromSerializedString and ToSerializedString methods (if anyone actually uses those).

More Related Contents:

  1. .NET DateTime.Now returns incorrect time when time zone is changed
  2. How to control appearance of ‘:’ in time zone offset when parsing/formatting Datetime
  3. DateTime vs DateTimeOffset
  4. Parse DateTime with time zone of form PST/CEST/UTC/etc
  5. Creating a DateTime in a specific Time Zone in c#
  6. Calculate week of month in .NET
  7. How do I convert an Excel serial date number to a .NET DateTime?
  8. Why can’t DateTime.ParseExact() parse “9/1/2009” using “M/d/yyyy”
  9. SqlDateTime.MinValue != DateTime.MinValue, why?
  10. What is the correct format to use for Date/Time in an XML file
  11. JavaScriptSerializer UTC DateTime issues
  12. datetime to string with time zone
  13. Can you round a .NET TimeSpan object?
  14. Difference between UTC and GMT Standard Time in .NET
  15. How do I parse and convert DateTime’s to the RFC 822 date-time format?
  16. How to convert date format in vb.net?
  17. When Would You Prefer DateTime Over DateTimeOffset
  18. .net: How to parse a date with this format: 08 Feb 2011 06:46
  19. Run code on UI thread in WinRT
  20. Bulk Insert to Oracle using .NET
  21. What’s a good way to trim all whitespace characters from a string in T-SQL without UDF and without CLR?
  22. Batching DB commands in Entity Framework 4.0
  23. How to create a WPF Window without a border that can be resized via a grip only?
  24. How to raise PropertyChanged event without using string name
  25. How to prevent Visual Studio from launching WcfSvcHost.exe while debugging?
  26. Regex for string not containing multiple specific words
  27. how do I work around log4net keeping changing publickeytoken
  28. system.data.sqlite .net 4
  29. SQL Connection Error: System.Data.SqlClient.SqlException (0x80131904)
  30. Why do I get a warning icon when I add a reference to an MEF plugin project?

Leave a Comment