log10

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 – Calculates the base 10 log of 20:

  select log10(20)

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

Usage

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute log10.