EXP()

Natural exponent

Result type

DOUBLE PRECISION

Syntax

EXP (number)

Table 1. `EXP` Function Parameter
Parameter	Description
number	A number of a numeric type

Returns the natural exponential, e^number

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.