Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

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.