SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—540440-003

9-13

ATAN Function

The ATAN function returns the arctangent of a numeric value expression as an angle

expressed in radians.

ATAN is an SQL/MX extension.

numeric-expression

is an SQL numeric value expression that specifies the value for the argument of

the ATAN function. See Numeric Value Expressions on page 6-48.

Examples of ATAN

•

This function returns the value 8.72766423249958400E-001 or approximately

0.8727 in radians (which is 50 degrees):

ATAN (1.192)

•

This function returns the value 0.8727. The function ATAN is the inverse of the

function TAN.

ATAN (TAN (0.8727))

ATAN2 Function

The ATAN2 function returns the arctangent of the x and y coordinates, specified by two

numeric value expressions, as an angle expressed in radians.

ATAN2 is an SQL/MX extension.

numeric-expression-x,numeric-expression-y

are SQL numeric value expressions that specify the value for the x and y

coordinate arguments of the ATAN2 function. See Numeric Value Expressions on

page 6-48.

Examples of ATAN2

•

This function returns the value 2.66344329881899600E+000, or approximately

2.6634:

ATAN2 (1.192,-2.3)

ATAN (numeric-expression)

ATAN2 (numeric-expression-x,numeric-expression-y)