Help Center > > FAQs> Database Parameter Modification> How Can I Change the Time Zone?

How Can I Change the Time Zone?

Updated at: Apr 20, 2020 GMT+08:00

Different DB engines have different time zone policies.

MySQL and PostgreSQL allows you to select a time zone when you create a DB instance and change the time zone after the instance is created.

SQL Server allows you to select a time zone when you create a DB instance but you cannot change the time zone after the instance is created.

To change the time zone for a MySQL or PostgreSQL DB instance, perform the following steps:

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click RDS. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance.
  5. On the Parameters page, locate the time zone parameter and change its value. Then, click Save. In the displayed dialog box, click Yes.

    • For MySQL, the time zone parameter is time_zone.
    • For PostgreSQL, the time zone parameter is timezone.

  6. Restart the application and client for the modification to take effect.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel