Outdated Version

You are viewing an older version of this section. View current production version.

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