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, 939🔥, 0💬
Popular Posts:
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...