Converts data types into other data types based on specified parameters. If the conversion cannot be performed, CAST returns an error. To return a NULL value instead, use TRY_CAST.

Syntax

CAST(<value> AS <type>)

Parameters

ParameterDescriptionSupported input types
<value>The value to convert or an expression that results in a value to convert.Any
<type>The target data type (case-insensitive)Any

Return Types

Same data type as <type>

Example

The following example returns 1 as an integer:

SELECT CAST('1' AS INTEGER) as level;

Returns: 1

CAST can also be done by writing the format before the object, for example - SELECT DATE '2022-01-01' , SELECT TIMESTAMP '2022-01-01 01:02:03'.

CAST can also be done by using the :: operator. For more information, see :: operator for CAST.