You can call the DescribeCollationTimeZones operation to query the character set collations and time zones available for use in ApsaraDB RDS.

Note This operation is supported only for instances that run SQL Server 2012 or later.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer automatically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String Yes DescribeCollationTimeZones

The operation that you want to perform. Set the value to DescribeCollationTimeZones.

Response parameters

Parameter Type Example Description
CollationTimeZones Array

An array that consists of the character set collations and time zones that are available for use in ApsaraDB RDS.

CollationTimeZone
Description String Kabul

The description of the character set collations and time zones.
StandardTimeOffset String (UTC+04:30)

The offset of the UTC time. The offset is in the following format: (UTC+<i>HH:mm</i>).
TimeZone String Afghanistan Standard Time

The time zone that is available for use in ApsaraDB RDS.
RequestId String 4EAED246-DB18-4C8D-9EB5-C319626F2A77

The ID of the request.

Examples

Sample requests

http(s)://rds.aliyuncs.com/? Action=DescribeCollationTimeZones
&<Common request parameters>

Sample success responses

XML format 

<DescribeCollationTimeZonesResponse>
	  <CollationTimeZones>
		    <CollationTimeZone>
			      <StandardTimeOffset>(UTC+04:30)</StandardTimeOffset>
			      <Description>Kabul</Description>
			      <TimeZone>Afghanistan Standard Time</TimeZone>
		    </CollationTimeZone>
	  </CollationTimeZones>
	  <RequestId>4EAED246-DB18-4C8D-9EB5-C319626F2A77</RequestId>
</DescribeCollationTimeZonesResponse>

JSON format 

{
    "CollationTimeZones": {
        "CollationTimeZone": [
            {
                "StandardTimeOffset": "(UTC+04:30)",
                "Description": "Kabul",
                "TimeZone": "Afghanistan Standard Time"
            }
        ]
    },
    "RequestId": "4EAED246-DB18-4C8D-9EB5-C319626F2A77"
}

Error codes

For a list of error codes, visit the API Error Center.