Skip to main content
Last updated on

EXP

Description​

Returns x raised to the base e.

Alias​

  • DEXP

Syntax​

EXP(<x>)

Parameters​

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