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

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