Skip to main content

ISNAN

Description

Determines whether the specified value is NaN (Not a Number).

Syntax

ISNAN(<value>)

Parameters

ParameterDescription
<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 |
+-------------+