Returns the natural logarithm of the given float expression.

LOG (float_expression )

Arguments

  • float_expression
    An expression of the type float, or of types that can be implicitly converted to float.

float

Example

The following example returns the logarithm of various float values.

CREATE TABLE Logarithms ([LOG 2] float, [LOG 20] float, [LOG 200] float);
INSERT INTO Logarithms VALUES (LOG(2), LOG(20), LOG(200));
SELECT * FROM Logarithms;