VeloDB Cloud
SQL Manual
Functions
math-functions
log10

log10

Description

Syntax:

DOUBLE log10(DOUBLE x)

This function returns the logarithm of x to the base of 10.

Example

mysql> select log10(1);
+------------+
| log10(1.0) |
+------------+
|          0 |
+------------+
mysql> select log10(10);
+-------------+
| log10(10.0) |
+-------------+
|           1 |
+-------------+
mysql> select log10(16);
+--------------------+
| log10(16.0)        |
+--------------------+
| 1.2041199826559248 |
+--------------------+

Keywords

LOG10