CAST

CAST is used to convert an expression of one data type to another.

Syntax

sql

1. CAST (expression AS data_type)

Parameters

• expression: the expression to be converted.
• data_type: the data type to convert the expression to.

Examples

Convert a string to an integer:

sql

1. SELECT CAST('123' AS INT) ;

sql

1. +-------------+
2. | Utf8("123") |
3. +-------------+
4. |         123 |
5. +-------------+