INFINITY

All functions > CONSTANT > INFINITY

Returns the floating-point representation of positive infinity.

Syntax

INFINITY()
sql

Arguments

ParameterTypeRequiredDescription

Returns

DOUBLE - Positive infinity

Notes

  • Represents positive infinity in floating-point arithmetic
  • Used in mathematical calculations involving limits
  • Greater than any finite number
  • Infinity + any finite number = Infinity
  • Infinity / finite number = Infinity

Examples

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