SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-73
LOG Function
LOG Function
The LOG function returns the natural logarithm of a numeric value expression.
LOG is an SQL/MX extension.
numeric-expression
is an SQL numeric value expression that specifies the value for the argument of
the LOG function. The value of the argument must be greater than zero. See
Numeric Value Expressions on page 6-48.
Examples of LOG
•
This function returns the value 6.93147180559945504E-001, or approximately
0.69315:
LOG (2.0)
LOG10 Function
The LOG10 function returns the base 10 logarithm of a numeric value expression.
LOG10 is an SQL/MX extension.
numeric-expression
is an SQL numeric value expression that specifies the value for the argument of
the LOG10 function. The value of the argument must be greater than zero. See
Numeric Value Expressions on page 6-48.
Examples of LOG10
•
This function returns the value 1.39794000867203792E+000, or approximately
1.3979:
LOG10 (25)
LOG (numeric-expression)
LOG10 (numeric-expression)