LOG10 Function

Returns the base-10 logarithm of a numeric value expression.

Category: Mathematical
Returned data type: DOUBLE

Syntax

LOG10(expression)

Arguments

expression

specifies any valid SQL expression that evaluates to a numeric value.

Data type DOUBLE
See <sql-expression>
FedSQL Expressions

Example

The following statements illustrate the LOG10 function:
Statements
Results
select log10(1.0);
0
select log10(10.0);
1
select log10(100.0);
2

See Also

Last updated: February 23, 2017