isfinite()

Returns true if the floating point value is finite, false otherwise

Reference: DuckDB 2.0.0

Arguments & returns

5 overloads

isfinite(x)

Scalar
Overload link x Returns
#01 DATE BOOLEAN
#02 DOUBLE BOOLEAN
#03 FLOAT BOOLEAN
#04 TIMESTAMP BOOLEAN
#05 TIMESTAMP WITH TIME ZONE BOOLEAN

Example

isfinite example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.