LOG10

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Scalar Functions >

LOG10

Previous pageReturn to chapter overviewNext page

LOG10 ( <number-expression> )

 

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.

Examples

Function

Result

LOG10(1)

0.0

LOG10(100)

2.0

log10(cast('23' as decimal))

1.3617278360175928

Notes

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