# exp

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: exp
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-functions/math-functions/exp
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/math-functions/exp.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/math-functions/exp.adoc
description: The `exp()` function returns the exponential value of a number specified in the argument.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/math-functions/exp.md -->

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

## [](#syntax)Syntax

The syntax for the `exp()` is:

```sql
EXP(number);
```

Where:

-   `number`: The number for which to calculate the exponential value. Equivalent to the formula `e^number`.


## [](#examples)Examples

The examples here show how the `exp()` function works.

### [](#basic-usage)Basic usage

This example uses the `exp()` function with positive and negative values.

```sql
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";
```

The query returns:

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

### [](#use-exp-with-fractions)Use `exp()` with fractions

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

```sql
SELECT EXP(3.2);
```

Here is the result:

```sql
        exp
--------------------
 24.532531366911574
```

### [](#use-exp-with-expressions)Use `exp()` with expressions

This example uses the `exp()` function with expressions.

```sql
SELECT EXP(5 * 5);
```

The query returns:

```sql
        exp
-------------------
 72004899337.38588
```