LOG10

Returns the base 10 logarithm of the input argument. If the argument is negative or 0, an exception is raised. Returns null if the input argument is null.

Syntax

LOG10 ( <number-expression> )

Examples

Function Result
LOG10(1) 0.0
LOG10(100) 2.0
log10(cast(‘23’ as decimal)) 1.3617278360175928

Notes

LOG10 is not a SQL standard function; it is a SQLstream extension to the standard.