Release Notes
Product Announcements
Modify System Time Zone
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/two-node cloud disk/multi-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, two-node cloud disk, or multi-node cloud disk instance, you can directly modify the system time zone on the 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-node, two-node, and multi-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
1. Log in to the TencentDB for SQL Server console.
2. In the instance list, click Create Database Instance.
3. On the instance purchase page, set the System Time Zone under the Instance Configuration.
4. For more information on how to configure other parameters on the purchase page, see Creating TencentDB for SQL Server Instance. After setting all the parameters, click Buy Now.
5. You can view the configured system time zone on the Instance Details page.
Comparsion table of time zones and UTC offsets
Region | Standard Time Offset | System Time Zone |
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 |
Related APIs
API | Description |
This API is used to query the character set and time zone supported by the instance. |
피드백