Configure time zones on MySQL Database on Azure

MySQL Database on Azure currently supports changing the time zone by modifying the parameter settings.

To do so, sign in to the Azure portal and, under server parameters, change the time_zone parameter. The system time for MySQL Database on Azure currently defaults to Coordinated Universal Time (UTC), but you can update the time by configuring the offset value. For example, +08:00 corresponds to UTC+8 (Beijing time), and -06:00 corresponds to the UTC-6 time zone.

For details about specific intervals and other parameters, see Customize MySQL Database on Azure server parameters.

If you want to switch to Beijing time, you can set the time_zone parameter to +08:00, as shown in the following image:

Beijing time setting

Note

The use of named regions, such as Europe/Helsinki, US/Eastern, or MET is not currently supported.