Returns true if the value of an expression is NaN (Not a Number), or false otherwise.
Syntax
boolean isnan(<expr>)Parameters
expr: required. DOUBLE. If the input is STRING, BIGINT, or DECIMAL, it is implicitly converted to DOUBLE before evaluation.
Return value
| Condition | Return value |
|---|---|
expr is NaN |
true |
expr is not NaN |
false |
expr is null |
false |
Examples
Check whether a literal value is NaN:
-- Returns false.
SELECT isnan(100.1);Related functions
ISNAN is a mathematical function. For more information about functions related to data computing and conversion, see Mathematical functions.