Skip to main content
Version: 3.2

log10, dlog10

Description

Calculates the base 10 logarithm of a number.

Syntax

log10(arg)

Parameters

  • arg: The value whose logarithm you want to calculate. Only DOUBLE data type is supported.

NOTE

StarRocks returns NULL if arg is specified as a negative or 0.

Return value

Returns a value of the DOUBLE data type.

Example

Example 1: Calculate the base 10 logarithm of 100.

select log10(100);
+------------+
| log10(100) |
+------------+
| 2 |
+------------+
1 row in set (0.02 sec)