Getting started
User guides
Administration guides
Reference guides
Resources
Updated Aug 04, 2022
Send us feedback
log
Returns the logarithm of expr with base.
expr
base
log( [base,] expr)
base: An optional expression that evaluates to a numeric.
expr: An expression that evaluates to a numeric.
A DOUBLE.
If base or expr are less than or equal to 0 the result is NULL. log(expr) is a synonym for ln(expr).
log(expr)
ln(expr)
> SELECT log(10, 100); 2.0 > SELECT log(e()); 1.0
log10 function
ln function
log1p function
pow function