LOG10()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the base-10 logarithm of the argument.
USAGE
LOG10(number)
Argument Name | Description |
|---|---|
| The number to transform |
DETAILS
LOG10() is a mathematical function that returns the common logarithm (base-10) of the argument. This is equivalent to calling LOG(10, number).
LOG10() returns a value with a DOUBLE data type. If the argument value or the computed value exceeds DOUBLE precision, an error is returned.
A NULL is returned if the argument is NULL or less than or equal to zero.
EXAMPLES
SELECT LOG10(2), LOG10(10);
+------------------+-----------+
| LOG10(2) | LOG10(10) |
+------------------+-----------+
| 0.30102999566398 | 1 |
+------------------+-----------+