Skip to main content
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

​
Parameters

​
Return Types

Same data type as <type>

​
Example

The following example returns 1 as an integer:

Rows: 1Execution time: 4.93ms

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.