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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-6
Mathematical Functions
See the individual entry for the function.
EXP Function on
page 9-51
Returns the exponential value (to the base e) of a numeric value
expression.
FLOOR Function
on
page 9-60
Returns the largest integer less than or equal to a numeric value
expression.
LOG Function
on
page 9-73
Returns the natural logarithm of a numeric value expression.
LOG10 Function
on
page 9-73
Returns the base 10 logarithm of a numeric value expression.
MOD Function
on
page 9-84
Returns the remainder (modulus) of an integer value expression
divided by an integer value expression.
PI Function
on
page 9-104
Returns the constant value of pi as a floating-point value.
POWER Function
on
page 9-106
Returns the value of a numeric value expression raised to the power
of an integer value expression. You can also use the exponential
operator **.
RADIANS Function
on page 9-116
Converts a numeric value expression expressed in degrees to the
number of radians.
SIGN Function
on
page 9-139
Returns an indicator of the sign of a numeric value expression. If
value is less than zero, returns -1 as the indicator. If value is zero,
returns 0. If value is greater than zero, returns 1.
SIN Function
on
page 9-140
Returns the sine of a numeric value expression, where the
expression is an angle expressed in radians.
SINH Function
on
page 9-140
Returns the hyperbolic sine of a numeric value expression, where
the expression is an angle expressed in radians.
SQRT Function
on
page 9-141
Returns the square root of a numeric value expression.
TAN Function
on
page 9-149
Returns the tangent of a numeric value expression, where the
expression is an angle expressed in radians.
TANH Function
on
page 9-149
Returns the hyperbolic tangent of a numeric value expression,
where the expression is an angle expressed in radians.