LOG10

Returns the 10-base logarithm value of a numeric expression

See also LOG (natural).

Syntax

LOG10( expr )

Arguments

Parameter

Description

expr

Positive numeric expression

Returns

When using the LOG10 floating point number scalar function, real arguments are automatically cast to double precision.

Notes

  • If the input value is NULL, the result is NULL.

Examples

Log (base 10) values

numbers=> SELECT LOG10(0.0001), LOG10(1), LOG10(100), LOG10(1000000);
log10 | log100 | log101 | log102
------+--------+--------+-------
   -4 |      0 |      2 |      6