tencent cloud

TDSQL Boundless

DokumentasiTDSQL BoundlessUser GuideRead-Only Analysis InstanceFeature Limits and CompatibilityDescription of Functions and OperatorsDescription of Supported Type Conversion Functions

Description of Supported Type Conversion Functions

Download
Mode fokus
Ukuran font
Terakhir diperbarui: 2026-07-10 11:13:51
In a read-only analysis instance, implicit type conversions due to column type mismatches may occur during SQL operations, or you may explicitly use the CAST function for type conversion. This document details the type conversion support provided by the read-only analysis instance.
Attention:
In SQL expressions, implicit type conversion is triggered when values of different types are compared or calculated. The supported range for all implicit conversions is defined by the conversion matrix shown in the table below. If you compare or calculate data types that do not support implicit conversion, an error is reported indicating that such conversion is not supported.
Syntax: CAST(expression AS data_type)
The type conversion support provided by the read-only analysis instance is shown in the table below (✓ indicates supported, × indicates not supported).
Source \\ Target
Int/Bigint
Binary
Char
Date
DateTime
Decimal
Double
Float
Real
Signed
Time
Unsigned
Year
Int/Bigint
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Binary
✓
✓
×
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Date
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Datetime
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Decimal
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Double
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Float
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Real
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Signed
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Time
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Unsigned
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Year
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Varchar
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Topik sebelumnya: Description of Supported JSON FunctionsTopik selanjutnya: Data Types

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan