Checks whether the value of an expression is NaN. If the value is NaN, True is returned. Otherwise, False is returned.
Syntax
boolean isnan(<expr>)Parameters
expr: required. The value is of the DOUBLE type. If the input value is of the STRING, BIGINT, or DECIMAL type, the value is implicitly converted into a value of the DOUBLE type before calculation.
Return value
If the value of expr is NaN, True is returned. Otherwise, False is returned.
If the value of expr is null, False is returned.
Examples
-- The value False is returned.
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.