Using C# (the .NET framework), I'm looping through all the TimeZones and their AdjustmentRules... and for "Mauritius Standard Time" {(GMT+04:00) Port Louis)} - the adjustment rule is as follows:
IsFixed = false;
DaylightTransitionStart.Month = 10;
DaylightTransitionEnd.Month = 1;
From what I understand, 'IsFixed=false' means that I do not use the "StartDate" and "EndDate" fields... but rather, I need to use the DaylightTransitionStart and End to dynamically determine if the time is in daylight time or not.
THE PROBLEM here is that, for about 30 transition rules, the "StartMonth" is AFTER the "EndMonth"
How can DaylightSavingsTime start in 'October 2008' and end in 'January 2008'?
Please help me to understand this... once I get past this hurdle, I should have a complete "convert any time to and from UTC with any time zone for all history" SQL function written.