Conversion functions
Important
Amazon S3 Select is no longer available to new customers. Existing customers of Amazon S3 Select can continue to use the feature as usual. Learn more
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 (expressionASdata_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)
