Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
LOG10
Returns the logarithm of the given argument to base 10.
Syntax
LOG10 ( number )
Arguments
- number: the number to take the logarithm of.
Info
LOG10(n) is equivalent to LOG(n) / LOG(10).
Return Type
Float or double. If number is less than or equal to 0, or if base is non-positive or 1, returns NULL.
Examples
SELECT LOG10(1000);
+-------------+
| LOG10(1000) |
+-------------+
| 3 |
+-------------+
