tencent cloud

Feedback

Modify System Time Zone

Last updated: 2024-01-18 17:20:33
    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.
    
    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 query the configured system time zone under Basic Info on the Instance Details tab.
    

    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
    
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support