NAN()

All functions > MATH > NAN()

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

Signatures

NaN

Returns: NaN

NAN() → DOUBLE

Signature notes:

• Represents an undefined or unrepresentable value
• NaN is not equal to any value, including itself
• Any arithmetic with NaN results in NaN

Examples

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