SqlExpression LOG10

From Eigenpedia

Contents 1 Syntax 2 Purpose 3 Input 4 Output 5 Example

Syntax

LOG10( numeric_expression )

Purpose

Returns the base 10 logarithm for numeric_expression. Note that this does not appear to be a SQL2003 standard function.

Input

• numeric_expression - input to the base 10 logarithm function

Output

• [NUMERIC] - output of the base 10 log function. Returns null on null input. If input is 0 or negative, exception is raised.

Example

Function	Result
LOG10(1000)	3
LOG10(cast(10e-9 as float))	-8
LOG10(19)	1.2787536009528289

---

Return to Built in Function details