s3-glacier-select-sql-reference-conversion
Conversion Functions
Amazon S3 Select and S3 Glacier Select support the following conversion functions.
Topics
CAST
The CAST function converts an entity, such as an expression that evaluates to a single value, from one type to another.
Syntax
CAST ( expression AS data_type )
Parameters
expression
A combination of one or more values, operators, and SQL functions that evaluate to a value.
data_type
The target data type, such as INT, to cast the expression to. For a list of supported data types, see Data Types.
Examples
CAST('2007-04-05T14:30Z' AS TIMESTAMP)
CAST(0.456 AS FLOAT)