EXP()

All functions > MATH > EXP()

Returns e raised to the power of the given number.

Signatures

Exponential

Returns: Value of e^exponent

EXP(exponent: T) → DOUBLE
sql
ParameterTypeRequiredDescription
exponentTYesPower to raise e to

With:

  • T : Floating-point type (FLOAT, DOUBLE)

Signature notes:

  • EXP(0.0) = 1
  • Inverse of the natural logarithm: EXP(LN(x)) = x
  • Returns NULL if the input is NULL
  • Can overflow to infinity for large exponents

Examples

FeatureQL
SELECT
    f1 := EXP(0.0E0), -- e^0 equals 1
    f2 := EXP(1.0E0), -- e^1 equals e
    f3 := EXP(2.0E0), -- e squared
    f4 := EXP(-1.0E0) -- Negative exponent
;
Result
f1 VARCHARf2 VARCHARf3 VARCHARf4 VARCHAR
1.02.7182818284590457.389056098930650.36787944117144233

Last update at: 2026/05/26 17:22:09