This document describes how to modify the system time zone when creating a SQL Server instance.
Note:
Dual-Node Local Disk Instance:
As modifying the system time zone requires to separately configure physical machine resources, submit a ticket for assistance and specify the desired system time zone if any modifications are needed before purchase. Modifications are only supported when purchasing instances of the 90-core 720GB specification. If you need to modify the system time zone, it is recommended to directly purchase the cloud disk version of the dual-node instance, which can be directly modified on the purchase page without specification restrictions. For instances with modified system time zone, the actual data stored in the background is the modified UTC time. After converting, the files of backup and rollback, and slow query logs are displayed in the frontend of the console in Beijing time, and the monitoring time is Beijing time.
For instances with modified system time zone, if a subsequent expansion involves data migration, submit a ticket for assistance. The default system time zone for instances is China Standard Time (Beijing time) .
Single-Node Cloud Disk/Dual-Node Cloud Disk Instances:
The system time zone can be modified directly on the purchase page.
For instances with modified system time zone, the actual data stored in the background is the modified UTC time. After converting, the files of backup and rollback, and slow query logs are displayed in the frontend of the console in Beijing time, and the monitoring time is Beijing time.
For instances with modified system time zone, if a subsequent expansion involves data migration, submit a ticket for assistance. Prerequisites
If your instance is a dual-node local disk instance, submit a ticket before modifying the system time zone. If you purchase a single-node cloud disk or dual-node cloud disk, you can directly modify the system time zone on purchase page with no need for application.
Use limits
Limits on instance architecture and specification
For dual-node local disk instances, submit a ticket to request a modification of the system time zone. Modifications are only supported when purchasing instances of the 90-core 720GB specification. Single and dual-node cloud disk instances support system time zone modifications.
Limits on time zone modification
The system time zone can be modified only during instance purchase, modifications are not supported after purchase.
Directions
2. In the instance list, click Create Database Instance.
3. On the instance purchase page, set the System Time Zone under the Tag parameter.
5. You can query the configured system time zone under Basic Info on the Instance Details tab.
Comparsion table of time zones and UTC offsets
|
Asia/Shanghai | (UTC+08:00) | China Standard Time |
Asia/Singapore | (UTC+08:00) | Singapore Standard Time |
America/New_York | (UTC-05:00) | Eastern Time (US & Canada) |
Asia/Seoul | (UTC+09:00) | Korea Standard Time |
Asia/Bangkok | (UTC+07:00) | N. Central Asia Standard Time |
Asia/Tokyo | (UTC+09:00) | Tokyo Standard Time |
Asia/Taipei | (UTC+08:00) | Taipei Standard Time |
Asia/Jakarta | (UTC+07:00) | SE Asia Standard Time |
Europe/London | (UTC) | Universal Time Coordinated |
Europe/London | (UTC) | Greenwich Mean Time |
Was this page helpful?