Cloud

log10

The log10() function returns the base-10 logarithm of a given number. It is equivalent to calling log() with a single argument.

Syntax

LOG10(x)

Arguments

  • x: A positive number of type real or double precision.

Return type

Same as the input type (real or double precision).

Examples

Basic usage

SELECT LOG10(1000);
 log10
-------
     3
(1 row)

Fractional result

SELECT LOG10(2);
        log10
--------------------
 0.3010299956639812
(1 row)