SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
9-6
Mathematical Functions
See the individual entry for the function.
COS Function on
page 9-37
Returns the cosine of a numeric value expression, where the
expression is an angle expressed in radians.
COSH Function
on
page 9-37
Returns the hyperbolic cosine of a numeric value expression, where
the expression is an angle expressed in radians.
EXP Function
on
page 9-65
Returns the exponential value (to the base e) of a numeric value
expression.
FLOOR Function
on
page 9-78
Returns the largest integer less than or equal to a numeric value
expression.
LOG Function
on
page 9-93
Returns the natural logarithm of a numeric value expression.
LOG10 Function
on
page 9-93
Returns the base 10 logarithm of a numeric value expression.
MOD Function
on
page 9-106
Returns the remainder (modulus) of an integer value expression
divided by an integer value expression.
PI Function
on
page 9-130
Returns the constant value of pi as a floating-point value.
POWER Function
on
page 9-132
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-143
Converts a numeric value expression expressed in degrees to the
number of radians.
SIGN Function
on
page 9-168
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-169
Returns the sine of a numeric value expression, where the
expression is an angle expressed in radians.
SINH Function
on
page 9-169
Returns the hyperbolic sine of a numeric value expression, where
the expression is an angle expressed in radians.
SQRT Function
on
page 9-170
Returns the square root of a numeric value expression.
TAN Function
on
page 9-178
Returns the tangent of a numeric value expression, where the
expression is an angle expressed in radians.
TANH Function
on
page 9-178
Returns the hyperbolic tangent of a numeric value expression,
where the expression is an angle expressed in radians.