Lesson Learned #73: Azure Database for MySQL – CONVERT_TZ returns null

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

Hello Team,

 

Today, we have a new service request where our customer asked about the CONVERT_TZ function to convert time to CET, but, unfortunately the function always returns null.

 

Searching in several MySQL webs we found that it is needed to run a process to load the different time zones as are described in these URLs:

 

As you know you don't have access to Azure Database for MySQL instance but, following the article https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters and see the part of “Working with the time zone parameter” there, you will have this option available.

 

Enjoy!

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.