EXP

All functions > MATH > EXP

Returns e raised to the power of the given number (exponential function).

Signatures

Returns: Result of e^exponent

EXP(exponent: T) → DOUBLE

Notes

• e^x is the natural exponential function
• EXP(0) = 1
• EXP(1) = e ≈ 2.718281828459045
• Returns NULL if the input is NULL
• Inverse of the natural logarithm: EXP(LN(x)) = x
• Can result in very large numbers for large exponents

Examples

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
    f5 := EXP(0.5e0)  -- Square root of e
;