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.
