LOG

All functions > MATH > LOG

Returns the logarithm of a number to a specified base.

Signatures

Returns: Logarithm result

LOG(base: T, number: T) → DOUBLE

Notes

• Both base and number must be positive
• Base cannot be 1
• LOG(base, 1) = 0 for any valid base
• LOG(base, base) = 1 for any valid base
• Returns NULL if any input is NULL
• Common bases: 10 (common log), 2 (binary log), e (natural log)

Examples

SELECT
    f1 := LOG(10e0, 100e0),  -- Log base 10 of 100
    f2 := LOG(10e0, 1000e0),  -- Log base 10 of 1000
    f3 := LOG(2e0, 8e0),  -- Log base 2 of 8
    f4 := LOG(2e0, 16e0),  -- Log base 2 of 16
    f5 := LOG(3e0, 27e0),  -- Log base 3 of 27
    f6 := LOG(10e0, 1e0)  -- Log of 1 is always 0
;