Aller au contenu principal
Dernière mise à jour le

isnan function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns true if expr is NaN.

Syntax​

isnan(expr)

Arguments​

  • expr: An expression that evaluates to a numeric.

Returns​

A BOOLEAN.

Examples​

SQL
> SELECT isnan(cast('NaN' as double));
 true
> SELECT isnan(7);
 false
Sur cette page