DLOG10 function - Amazon Redshift

DLOG10 function

The DLOG10 returns the base 10 logarithm of the input parameter.

Synonym of LOG function.

Syntax

DLOG10(number)

Argument

number

The input parameter is a DOUBLE PRECISION number.

Return type

DOUBLE PRECISION

Example

To return the base 10 logarithm of the number 100, use the following example.

SELECT DLOG10(100); +--------+ | dlog10 | +--------+ | 2 | +--------+