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.