Amazon S3 Glacier
Developer Guide (API Version 2012-06-01)

Conversion Functions

Amazon S3 Select and 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)

On this page: