tencent cloud

TDSQL Boundless

문서TDSQL BoundlessUser GuideRead-Only Analysis Instance Feature Limits and CompatibilityDescription of Functions and OperatorsDescription of Supported Type Conversion Functions

Description of Supported Type Conversion Functions

Download
포커스 모드
폰트 크기
마지막 업데이트 시간: 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
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
이전 주제: Description of Supported JSON Functions다음 주제: Data Types

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백