Conversion Operations

CAST

Syntax

CAST(<source_expr> AS <target_data_type>)

Description

Converts a value of one data type into another data type.

View examples

Formula Editor Example

Given the following table:

VALUE
314159.07
5535.79

Applied formula:

CAST()

Output:

VALUE_CAST
314159.0
5536.0

SQL Editor Example

Convert a string containing a number to a decimal with specified scale (2):

select cast('1.2345' as decimal(15,2));

Output

CAST('1.2345' AS DECIMAL(15,2))
1.23