Skip to main content

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