FLOOR()

Floor of a number

Result type

BIGINT or INT128 for exact numeric number, or DOUBLE PRECISION or DECFLOAT for floating point number

Syntax

FLOOR (number)

Table 1. `FLOOR` Function Parameter
Parameter	Description
number	An expression of a numeric type

Returns the largest whole number smaller than or equal to the argument.

Natural logarithm

Result type

DOUBLE PRECISION

Syntax

LN (number)

Table 1. `LN` Function Parameter
Parameter	Description
number	An expression of a numeric type

An error is raised if the argument is negative or 0.