Data Types

AMSelect query expressions use the following scalar data types.

Name	Description	Example
bool, boolean	A Boolean value, either TRUE or FALSE.	FALSE
int, integer	An 8-byte signed integer in the range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.	12345
string	A UTF-8-encoded variable-length string.	'abc'
float	An 8-byte floating point number.	CAST(0.456 AS FLOAT)
decimal, numeric	A base-10 number with precision and scale.	123.456
timestamp	Timestamps represent a specific moment in time and always include a local offset.	CAST('2007-04-05T14:30Z' AS TIMESTAMP)

Literals

String literals are enclosed in single quotes.

Numeric literals without a decimal point are integers.

Numeric literals with a decimal point are decimals.

TRUE and FALSE are Boolean literals.

NULL represents a missing SQL value.