Categories: Datatype, Variant Type

IS_TIMESTAMP Preview

Returns TRUE if the input expression is a VARIANT<TIMESTAMP>.

Syntax

IS_TIMESTAMP(value VARIANT) → BOOLEAN

• value: The VARIANT value to check.

Examples

IS_TIMESTAMP example

SELECT IS_TIMESTAMP(TO_VARIANT(CURRENT_TIMESTAMP))
-- TRUE

IS_TIMESTAMP example

SELECT IS_TIMESTAMP(TO_VARIANT('2024-01-15 12:30:00'))
-- FALSE

Usage Notes

NULL handling for VARIANT inputs

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

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