Data Type Conversion

Castable: explicit conversion with cast function.
Coercible: implicit conversion without cast function.

Github 来源:MatrixOne 浏览 46 扫码分享 2023-07-06 22:15:09

MatrixOne supports the conversion between different data types, the supported and unsupported conversions are listed in the following table.

Source Data Type	Target Data Type	Castable	Coercible
BOOLEAN	INTEGER	❌	❌
	DECIMAL	❌	❌
	VARCHAR	✔	✔
DATE	TIMESTAMP	✔	✔
	DATETIME	✔	✔
	VARCHAR	✔	✔
DATETIME	TIMESTAMP	✔	✔
	DATE	✔	✔
	VARCHAR	✔	✔
FLOAT(Floating-point number)	INTEGER	❌	❌
	DECIMAL	✔	✔
	VARCHAR	✔	✔
INTEGER	BOOLEAN	❌	❌
	FLOAT	✔	✔
	TIMESTAMP	✔	✔
	VARCHAR	✔	✔
	DECIMAL	✔	✔
TIMESTAMP	DATE	✔	✔
	DATETIME	✔	✔
	VARCHAR	✔	✔
VARCHAR	BOOLEAN	✔	✔
	DATE	✔	✔
	FLOAT	✔	✔
	INTEGER	✔	✔
	DECIMAL	✔	✔
	TIMESTAMP	✔	✔
	DATETIME	✔	✔

当前内容版权归 MatrixOne 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 MatrixOne .

本文档使用 BookStack 构建