Conditional and miscellaneous functions
CAST
Reference material for CAST function
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
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:
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.