Azure database for MySQL flexible server varying time zone setting

Gijs Romme 1 Reputation point
2022-07-05T10:58:03.41+00:00

Hi,

I have an Azure database for MySQL flexible server running for which I'd like to change the time zone setting to Europe/Amsterdam time. Currently, is it not possible to enter 'Europe/Amsterdam' (or any other strings) in the time zone server parameter field, but only values of the format +/- xx:xx. The problem for me is that during summer time, the time in Amsterdam is denoted by CET (UTC+01:00) during winter time and by CEST (UTC+02:00) during summer time. Now of course I could change the server parameter every time that the Netherlands goes from summer time to winter time or vice versa, but that's not really a convenient solution. Does anyone know any other ways to more conveniently solve my problem?

Best,

Gijs

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
990 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
    2022-07-06T00:59:04.677+00:00

    Hi, @Gijs Romme Welcome to the Microsoft Q&A Platform, and thanks for your query.
    Can you please try checking these document1, document2 Staying Current with Time Zone Changes, you will have to verify it as shown in that document.

    Regards
    Geetha


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.