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, 1171🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...