CAST
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
| Parameter | Description | Supported 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.