Help Center/ GaussDB(for MySQL)/ FAQs/ Database Parameter Modification/ How Do I Change the Time Zone of a GaussDB(for MySQL) Instance?
Updated on 2024-09-05 GMT+08:00
View PDF

How Do I Change the Time Zone of a GaussDB(for MySQL) Instance?

GaussDB(for MySQL) allows you to select a time zone when you create an instance and change the time zone after the instance is created.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
  4. On the Instances page, click the instance name.
  5. In the navigation pane, choose Parameters.
  6. Search for a time zone parameter in the search box, for example, time_zone.
  7. Select a time zone, and click Save.
  8. In the displayed dialog box, click Yes.

    For example, to change the time zone to UTC+08:00, select Asia/Shanghai from the drop-down list.

Time Zone Parameters

  • system_time_zone: operating system (OS) time zone. Changing the value of this parameter does not affect the database time zone.
  • time_zone: database time zone. You can modify this parameter to change the time zone for your instance.