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 |
+-------------+