EXP() - Exponential Based on E

Q

How to calculate the natural exponential of a given number using the EXP() function?

✍: FYIcenter.com

A

EXP(X) is a MySQL built-in function that calculates the natural exponential of a given number. For example:

SELECT EXP(-1.0), EXP(0.0), EXP(1.0);
  -- +---------------------+----------+-------------------+
  -- | EXP(-1.0)           | EXP(0.0) | EXP(1.0)          |
  -- +---------------------+----------+-------------------+
  -- | 0.36787944117144233 |        1 | 2.718281828459045 |
  -- +---------------------+----------+-------------------+

Reference information of the EXP() function:

EXP(X): val
  Returns the value of e (the base of natural logarithms) raised to the
  power of X. The inverse of this function is LOG() (using a single
  argument only) or LN().

Arguments, return value and availability:
  X: Required. The input value.
  val: Return value. The natural exponential of X.
  Available since MySQL 4.0.

Related MySQL functions:

 

EXPORT_SET() - Exporting Binary Set to On/Off Flags

FORMAT_BYTES() - Formatting Bytes in Readable Units

MySQL Functions on Numeric Values

⇑⇑ MySQL Function References

2023-11-14, 262🔥, 0💬