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.
LOG10 ( <number-expression> )
Function | Result |
---|---|
LOG10(1) | 0.0 |
LOG10(100) | 2.0 |
log10(cast(‘23’ as decimal)) | 1.3617278360175928 |
LOG10 is not a SQL standard function; it is a SQLstream extension to the standard.