Conversion functions
Amazon S3 Select supports the following conversion function.
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
ASdata_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)