ISNAN
Description
Determines whether the specified value is NaN (Not a Number).
Syntax
ISNAN(<value>)
Parameters
Parameter | Description |
---|---|
<value> | The value to be checked, which must be a DOUBLE or FLOAT type |
Return Value
Returns 1 if the value is NaN, otherwise returns 0. If the value is NULL, returns NULL.
Examples
SELECT isnan(1);
+----------+
| isnan(1) |
+----------+
| 0 |
+----------+
SELECT cast('nan' as double),isnan(cast('nan' as double));
+-----------------------+------------------------------+
| cast('nan' as double) | isnan(cast('nan' as double)) |
+-----------------------+------------------------------+
| NaN | 1 |
+-----------------------+------------------------------+
SELECT isnan(NULL)
+-------------+
| isnan(NULL) |
+-------------+
| NULL |
+-------------+