LOG10 Function [Numeric]

Returns the base 10 logarithm of a number.

Syntax

LOG10numeric-expression )

Parameters

Parameters

Parameter

Description

numeric-expression

The number.

Returns

This function converts its argument to DOUBLE, and performs the computation in double-precision floating point. If the parameter is NULL, the result is NULL.

Example

The following statement returns the value 1.698970.

SELECT LOG10( 50 ) FROM iq_dummy

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Compatible with Adaptive Server Enterprise.

Related reference
LN Function [Numeric]
LOG Function [Numeric]