You need to enable JavaScript to run this app.
RDS for SQL Server

RDS for SQL Server

Copy page
Download PDF
FAQ
How do I query the time zone and character set of RDS for SQL Server instance?
Copy page
Download PDF
How do I query the time zone and character set of RDS for SQL Server instance?
This article describes how to view the time zone and instance character set of a SQL Server instance.​
View the time zone where the SQL Server instance is located​
  • Method 1: View the time zone where the instance is located through the console​
  1. In the upper left corner of the top menu bar, select the project and region to which the instance belongs.​
  1. On the instance list page, click the target instance name.​
  1. In the Instance Information area of the Target Instance Instance In tab, you can view the time zone of the target instance.​
  • Method 2: Check the time zone of the instance through SSMS​
  1. Connect the instance via SSMS. For more details, see Connection instance .​
  1. Open a session and execute the following command to view the time zones supported by the instance.​
  • ​
    SELECT master.dbo.rds_fn_get_tz_info();​
    ​
View instance character sets​
  • Method 1: View the instance's character set through the console​
  1. In the upper left corner of the top menu bar, select the project and region to which the instance belongs.​
  1. On the instance list page, click the target instance name.​
  1. In the Instance Information area of the Target Instance Instance In tab, you can view the character set of the target instance.​
  • Method 2: View the instance character set through SSMS​
  1. Connect the instance via SSMS. For more details, see Connection instance.​
  1. Open a session and execute the following command to see the character sets supported by the instance.​
  • ​
    SELECT SERVERPROPERTY('Collation') AS InstanceCollation;​
    ​
​
Last updated: 2026.01.22 10:23:07