Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

LOG Function

Returns the base 10 logarithm of a number.

Synonym of DLOG10 Function.

Syntax

Copy
LOG(number)

Argument

number

The input parameter is a double precision number.

Return Type

The LOG function returns a double precision number.

Example

The following example returns the base 10 logarithm of the number 100:

Copy
select log(100); dlog10 -------- 2 (1 row)