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-5
Mathematical Functions
See the individual entry for the function.
Mathematical Functions
Use these mathematical functions within an SQL numeric value expression:
HOUR Function on page 9-83 Returns an integer value in the range 0 through
23 that represents the corresponding hour of the
day.
JULIANTIMESTAMP Function
on
page 9-85
Converts a datetime value to a Julian timestamp.
MINUTE Function
on page 9-105 Returns an integer value in the range 0 through
59 that represents the corresponding minute of
the hour.
MONTH Function
on page 9-107 Returns an integer value in the range 1 through
12 that represents the corresponding month of
the year.
MONTHNAME Function
on page 9-108 Returns a character literal that is the name of the
month of the year (January, February, and so
on).
QUARTER Function
on page 9-133 Returns an integer value in the range 1 through 4
that represents the corresponding quarter of the
year.
SECOND Function
on page 9-167 Returns an integer value in the range 0 through
59 that represents the corresponding second of
the minute.
WEEK Function
on page 9-212 Returns an integer value in the range 1 through
54 that represents the corresponding week of the
year.
YEAR Function
on page 9-213 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.