Syntax

CAST(value AS datatype[precision,scale])

Description

The CAST() function in Datameer's SQL worksheet converts a value into a specified data type.

Cast data type conversions in Datameer
AS TYPE[(precision,scale)]	resulting SheetColumnType
INTEGER	Integer
FLOAT	Float
DECIMAL(<20,0)	Integer
DECIMAL(>=20,0)	BigInteger
DECIMAL(<16,>=1)	Float
DECIMAL(>=16,>=1)	BigDecimal
DECIMAL	BigInteger
VARCHAR	String
BOOLEAN	Boolean
TIMESTAMP	Date