LOG10

On this page

Returns the logarithm of the given argument to base 10.

Syntax

SQL

LOG10 ( number )

Arguments

number: the number to take the logarithm of.

Note

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

SQL

SELECT LOG10(1000);

+-------------+
| LOG10(1000) |
+-------------+
|           3 |
+-------------+

Last modified: April 4, 2023

Was this article helpful?