Amazon Kinesis Data Analytics
SQL Reference

LOG10

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

Note

LOG10 is not a SQL:2008 standard function; it is an Amazon Kinesis Data Analytics extension to the standard.

On this page: