NAN

All functions > CONSTANT > NAN

Returns the floating-point representation of NaN (Not a Number).

Syntax

NAN()
sql

Arguments

ParameterTypeRequiredDescription

Returns

DOUBLE - NaN (Not a Number)

Notes

  • Represents an undefined or unrepresentable value
  • Results from invalid operations like SQRT(-1) or 0.0/0.0
  • NaN is not equal to any value, including itself
  • Any arithmetic operation with NaN results in NaN
  • Used to represent missing or invalid numeric data

Examples

Suggest changes to this page
Last update at: 2025/10/13 10:23:46