CAST

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

Syntax

  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:

  1. SELECT CAST('123' AS INT) ;
  1. +-------------+
  2. | Utf8("123") |
  3. +-------------+
  4. | 123 |
  5. +-------------+