Collections:
LOG10() - Logarithm to Base 10
How to calculate the logarithm of a number to base 10 using the LOG10() function?
✍: FYIcenter.com
LOG10(X) is a MySQL built-in function that calculates the logarithm of X to base 10. For example:
SELECT LOG10(1), LOG10(100), LOG10(2000); -- +----------+------------+--------------------+ -- | LOG10(1) | LOG10(100) | LOG10(2000) | -- +----------+------------+--------------------+ -- | 0 | 2 | 3.3010299956639813 | -- +----------+------------+--------------------+
Reference information of the LOG10() function:
LOG10(X): val Returns the base-10 logarithm of X. Arguments, return value and availability: X: Required. The input value. val: Return value. The logarithm of the input value to base 10. Available since MySQL 4.0.
Related MySQL functions:
⇒ LOG2() - Logarithm to Base 2
⇐ LOG() - Logarithm of Y to Base X
2023-11-15, 244🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
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 Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...