LOG

The LOG function returns the logarithm of the input argument.

Syntax

LOG (argument) 

Remarks

The table lists the valid input argument data types and the resulting output data types.

Data Type of Argument	Output Type	Note
BIGINT, DECIMAL, FLOAT, INTEGER, NUMERIC, REAL, SMALLINT, TINYINT	FLOAT	Input value should be greater than zero.
NULL	NULL

Example

SELECT LOG(3.1622776601683794);

The result is 0.5.