TRY_CAST()

All functions > CORE > TRY_CAST()

Returns the given expression casted to the given type, or NULL if the cast fails.

Signatures

Returns: The expression converted to the specified type, or NULL if conversion fails

TRY_CAST(expr: T, as_type: DataTypeEnum.TYPE) → U

Notes

• Converts a value from one data type to another
• Returns NULL instead of raising an error when the conversion fails
• Supports the same conversions as CAST
• Safe alternative to CAST when the input may contain invalid values
• NULL values remain NULL after casting

See also

• Core functions

Examples

Successful casts

SELECT
    f1 := TRY_CAST('123' AS BIGINT), -- Valid string to integer
    f2 := TRY_CAST(42 AS DOUBLE), -- Integer to double
    f3 := TRY_CAST('2024-01-15' AS DATE) -- Valid string to date
;

Invalid input → NULL

SELECT
    f1 := TRY_CAST('abc' AS BIGINT), -- Invalid string returns NULL
    f2 := TRY_CAST('not-a-date' AS DATE) -- Invalid date string returns NULL
;