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 |
+--------------+