SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
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-85 Returns an integer value in the range 1 through
12 that represents the corresponding month of
the year.
MONTHNAME Function
on page 9-86 Returns a character literal that is the name of the
month of the year (January, February, and so
on).
QUARTER Function
on page 9-108 Returns an integer value in the range 1 through 4
that represents the corresponding quarter of the
year.
SECOND Function
on page 9-140 Returns an integer value in the range 0 through
59 that represents the corresponding second of
the minute.
WEEK Function
on page 9-178 Returns an integer value in the range 1 through
54 that represents the corresponding week of the
year.
YEAR Function
on page 9-179 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-11
Returns the arccosine of a numeric value expression as an angle
expressed in radians.
ASIN Function
on
page 9-13
Returns the arcsine of a numeric value expression as an angle
expressed in radians.
ATAN Function
on
page 9-14
Returns the arctangent of a numeric value expression as an angle
expressed in radians.
ATAN2 Function
on
page 9-15
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-24
Returns the smallest integer greater than or equal to a numeric
value expression.
COS Function
on
page 9-33
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-48
Converts a numeric value expression expressed in radians to the
number of degrees.