log10

Description

Calculates 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

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute log10.

See also

Documentation Transact-SQL Users Guide

Functions log, power