Collections:
EXP() - Exponential Based on E
How to calculate the natural exponential of a given number using the EXP() function?
✍: FYIcenter.com
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
2023-11-14, 1415🔥, 0💬
Popular Posts:
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...