Configure time zones on MySQL Database on Azure

  • Article

MySQL Database on Azure currently supports changing the time zone by modifying the parameter settings. Log in to the Azure Management Portal and change the time_zone parameter within the server parameters. 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), while -06:00 corresponds to the UTC-6 time zone.

See Customize MySQL Database on Azure server parameters for details of specific intervals and other parameters.

Taking the example of a user that wishes to switch to Beijing time, the user can set the time_zone parameter to +08:00 as shown in the image below. Beijing time setting

Note

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