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

How Can I Change the Time Zone?

Updated at: Jul 07, 2021 GMT+08:00

You can set the time zone only on the RDS console.

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 in the upper left corner of the page and choose Database > Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance.
  5. In the navigation pane on the left, 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 OK.

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

    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 DB instance.

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