SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
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-102 Returns an integer value in the range 1 through
12 that represents the corresponding month of
the year.
MONTHNAME Function
on page 9-103 Returns a character literal that is the name of the
month of the year (January, February, and so
on).
QUARTER Function
on page 9-128 Returns an integer value in the range 1 through 4
that represents the corresponding quarter of the
year.
SECOND Function
on page 9-162 Returns an integer value in the range 0 through
59 that represents the corresponding second of
the minute.
WEEK Function
on page 9-207 Returns an integer value in the range 1 through
54 that represents the corresponding week of the
year.
YEAR Function
on page 9-208 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-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-60
Returns the exponential value (to the base e) of a numeric value
expression.