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
| Parameter | Type | Required | Description |
|---|---|---|---|
exponent | T | Yes | Power 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 VARCHAR | f2 VARCHAR | f3 VARCHAR | f4 VARCHAR |
|---|---|---|---|
| 1.0 | 2.718281828459045 | 7.38905609893065 | 0.36787944117144233 |
On this page