SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—544517-008
9-5
Mathematical Functions
See the individual entry for the function.
Mathematical Functions
Use these mathematical functions within an SQL numeric value expression:
MONTH Function on page 9-89 Returns an integer value in the range 1 through
12 that represents the corresponding month of
the year.
MONTHNAME Function
on page 9-90 Returns a character literal that is the name of the
month of the year (January, February, and so
on).
QUARTER Function
on page 9-111 Returns an integer value in the range 1 through 4
that represents the corresponding quarter of the
year.
SECOND Function
on page 9-142 Returns an integer value in the range 0 through
59 that represents the corresponding second of
the minute.
WEEK Function
on page 9-175 Returns an integer value in the range 1 through
54 that represents the corresponding week of the
year.
YEAR Function
on page 9-176 Returns an integer value that represents the
year.
ABS Function on
page 9-10
Returns the absolute value of a numeric value expression.
ACOS Function
on
page 9-10
Returns the arccosine of a numeric value expression as an angle
expressed in radians.
ASIN Function
on
page 9-12
Returns the arcsine of a numeric value expression as an angle
expressed in radians.
ATAN Function
on
page 9-13
Returns the arctangent of a numeric value expression as an angle
expressed in radians.
ATAN2 Function
on
page 9-13
Returns the arctangent of the x and y coordinates, specified by two
numeric value expressions, as an angle expressed in radians.
CEILING Function
on
page 9-22
Returns the smallest integer greater than or equal to a numeric
value expression.
COS Function
on
page 9-34
Returns the cosine of a numeric value expression, where the
expression is an angle expressed in radians.
COSH Function
on
page 9-34
Returns the hyperbolic cosine of a numeric value expression, where
the expression is an angle expressed in radians.
DEGREES Function
on page 9-47
Converts a numeric value expression expressed in radians to the
number of degrees.