log10

Description

Returns the base 10 logarithm of the specified number.

Syntax

log10(approx_numeric)

Parameters

approx_numeric

is any approximate numeric (float, real, or double precision) column name, variable, or constant expression.

Examples

Example 1

select log10(20)

-------------------- 
           1.301030 

Usage

Standards

SQL92 – Compliance level: Transact-SQL extension.

Permissions

Any user can execute log10.

See also

Functions log, power