SQL · Numeric functions

log()

A logarithm. PostgreSQL takes an explicit base; SQLite log(number) is base 10.

sqlRunnable example sql course

Syntax

log(base, number)

Example

Open in the lab

SELECT log(100) AS base10;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.