Categories: Datatype, Variant Type

IS_BIGINT Preview

Returns TRUE if the input expression is a BIGINT value.

Syntax

IS_BIGINT(expression any) → BOOLEAN

• expression: Input expression.

Examples

IS_BIGINT example

SELECT IS_BIGINT(column_name)
-- TRUE

IS_BIGINT example

SELECT IS_BIGINT(TO_VARIANT(CAST(9223372036854775807 AS BIGINT)))
-- TRUE

IS_BIGINT example

SELECT IS_BIGINT(TO_VARIANT('hello'))
-- FALSE

Usage Notes

NULL handling for VARIANT inputs

If the input is SQL NULL (e.g., from a missing path), IS_BIGINT returns NULL.

Input	Result
VARIANT bigint	TRUE
VARIANT other type	FALSE
VARIANT null	FALSE
SQL NULL	NULL