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, 1454🔥, 0💬
Popular Posts:
How to format a number of bytes in a human-readable unit using the FORMAT_BYTES() function? FORMAT_B...
What Are the Differences between BINARY and VARBINARY in MySQL? Both BINARY and VARBINARY are both b...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema in Oracle? For a us...
What Is Transport Network Substrate (TNS) in Oracle? TNS, Transport Network Substrate, is a foundati...