Conversion functions - Amazon Simple Storage Service
CAST
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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 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)