EXP

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