EXP

All functions > MATH > EXP

Returns e raised to the power of the given number (exponential function).

Syntax

EXP(exponent: T) → DOUBLE
sql

Type Parameters:

  • T: Any numeric type (TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL)

Arguments

ParameterTypeRequiredDescription
exponentTYesThe power to raise e to

Returns

DOUBLE - Result of e^exponent

Notes

  • e^x is the natural exponential function
  • EXP(0) = 1
  • EXP(1) = e ≈ 2.718281828459045
  • Returns NULL if the input is NULL
  • Inverse of the natural logarithm: EXP(LN(x)) = x
  • Can result in very large numbers for large exponents

Examples

Suggest changes to this page
Last update at: 2025/10/13 10:23:46