tencent cloud

TencentDB for MySQL

DocumentationTencentDB for MySQLOperation GuideRead-Only Analysis EngineFeature Limits and CompatibilityDescription of Functions and OperatorsDescription of Supported Type Conversion Functions

Description of Supported Type Conversion Functions

PDF
Focus Mode
Font Size
Last updated: 2025-05-09 11:51:19
In the read-only analysis engine, performing SQL operations may result in implicit conversions caused by mismatches in field types, or explicit type conversions may be specified using the CAST function. The support for type conversions varies across different versions of the read-only analysis engine. This document will provide a detailed description of the supported type conversion.
Note:
When values of different types are compared or calculated in an SQL expression, implicit conversion will occur. All implicit conversion logic that may occur during usage is subject to the conversion support conditions shown in the table below. If a value does not support implicit conversion in a comparison or calculation, an error message will be generated indicating that the conversion is not supported.
Syntax: CAST (expression AS data_type)
In the read-only analysis engine of version 1.2404.x, the detailed information about supported conversion types is shown in the table below.
Source/Destination
Binary
Char
Date
DateTime
Decimal
Double
Float
Real
Signed
Time
Unsigned
Year
Bigint
✓
✓
×
×
✓
✓
×
✓
✓
×
✓
×
Binary
✓
×
×
×
✓
✓
×
✓
✓
×
✓
×
Date
✓
×
✓
✓
×
×
×
×
×
✓
×
×
Datetime
✓
×
✓
✓
×
×
×
×
×
✓
×
×
Decimal
✓
✓
×
×
✓
✓
×
✓
✓
×
✓
×
Double
✓
✓
×
×
✓
✓
×
✓
×
×
×
×
Float
✓
✓
×
×
✓
×
✓
✓
✓
×
✓
×
Real
✓
✓
×
×
✓
✓
×
✓
×
×
×
×
Signed
✓
✓
×
×
✓
✓
×
✓
✓
×
✓
×
Time
×
×
×
×
×
×
×
×
×
×
×
×
Unsigned
✓
✓
×
×
✓
✓
×
✓
✓
×
✓
×
Year
✓
✓
×
×
✓
✓
×
✓
✓
×
✓
×
Varchar
✓
✓
×
×
✓
✓
×
✓
✓
×
✓
×
In the read-only analysis engine of version 2.2410.x, the detailed information about supported conversion types is shown in the table below.
Source/Destination
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
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
×
Previous Topic: JSON FunctionNext Topic: Data Type

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback