SQL · Numeric functions

ln()

The natural logarithm. PostgreSQL and MySQL; SQLite builds without math functions may omit it.

sqlRunnable example sql course

Syntax

ln(number)

Example

Open in the lab

-- PostgreSQL: SELECT ln(1);
SELECT 1 AS supported_by_postgres;

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