EXP
Description
Returns x raised to the base e.
Alias
- DEXP
Syntax
EXP(<x>)
Parameters
| Parameter | Description |
|---|---|
<x> | independent variable |
Return Value
Return a value of type double. Special cases:
- If the parameter is NULL, returns NULL
- When the parameter is quite large, returns Infinity
Example
select exp(2);
+------------------+
| exp(2.0) |
+------------------+
| 7.38905609893065 |
+------------------+
select exp(3.4);
+--------------------+
| exp(3.4) |
+--------------------+
| 29.964100047397011 |
+--------------------+
select exp(1000000);
+--------------+
| EXP(1000000) |
+--------------+
| Infinity |
+--------------+