NAN

All functions > MATH > NAN

Returns the floating-point representation of NaN (Not a Number).

Signatures

Returns: NaN (Not a Number)

NAN() → DOUBLE

Notes

• Represents an undefined or unrepresentable value
• Results from invalid operations like SQRT(-1) or 0.0/0.0
• NaN is not equal to any value, including itself
• Any arithmetic operation with NaN results in NaN
• Used to represent missing or invalid numeric data

Examples

SELECT
    f1 := IS_NAN(NAN())  -- NaN value
;