LOG10 returns the logarithm with base 10 of the specified value.
LOG10(value) is the same as using LOG(value, 10).
For a different base, use the LOG function instead.
This example return the base-10 logarithm of the input value.
SELECT LOG10(100) AS 'Log 100'
| Log 100 |
|---|
| 2 |
Syntax of the LOG10 function.
LOG10(value)
value -- a number greater than 0.
