Time Zone 'Central Standard Time (Mexico)' dont work properly

Question

Time Zone 'Central Standard Time (Mexico)' dont work properly on Azure Functions, Azure Web App, Azure SQL

Answer 1

@Gerardo García Calva Thank you for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.

Our engineering team has confirmed that this is a known issue and they have created an fix for windows os and this fix will be rolled out to the customers in their next release(No ETA at the moment).

At this moment the workaround to use custom TimeZoneInfo functionality in .NET.

For information, you can refer to this blog post for which windows operating systems this Mexico 2023 times updates are avaialable.

Answer 2

Hello @Gerardo Garcia Calva Until the fix arrive you can do this:

public static readonly Lazy<TimeZoneInfo> LazyMexicoTimeZoneInfo = new Lazy<TimeZoneInfo>(
            () =>
            {   
                const string displayName = "(GMT-06:00) México Tiempo del Centro";
                const string standardName = "México Tiempo del Centro (Horario de Siempre)";
                
                var offset = new TimeSpan(-6, 0, 0);
                var result = TimeZoneInfo.CreateCustomTimeZone(standardName, offset, displayName, standardName, null, null);

                return result;
            });