​
Overview

The EXP() function returns the exponential value of a number specified in the argument.

​
Syntax

The syntax for the EXP() is:

EXP(number);

Where:

  • number: The number for which you want to calculate the exponential value. Equivalent to the formula e^number.

​
Examples

Let’s explore examples to see how the EXP() function works.

​
Case #1: Basic Usage

In this case, we use the EXP() function with positive and negative values.

SELECT EXP(0) AS "EXP of 0", 
      EXP(1) AS "EXP of 1",
      EXP(2) AS "EXP of 2",
      EXP(-1) AS "EXP of -1",
      EXP(-2) AS "EXP of -2";

You will get the following result:

EXP of 0  |     EXP of 1      |     EXP of 2     |      EXP of -1      |     EXP of -2      
----------+-------------------+------------------+---------------------+--------------------
        1 | 2.718281828459045 | 7.38905609893065 | 0.36787944117144233 | 0.1353352832366127

​
Case #2: Using EXP() with Fractions

This case uses the EXP() function with a fractional argument.

SELECT EXP(3.2);

Here is the result:

        exp         
--------------------
 24.532531366911574

​
Case #3: Using EXP() with Expressions

Here, we use the EXP() function with expressions.

SELECT EXP(5 * 5);

See the result below:

        exp        
-------------------
 72004899337.38588
CEILFLOOR