Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

ATAN2 function (ODBC compatible)

Syntax

ATAN2 ( expression1 , expression2 )

Description

The scalar function ATAN2 returns the arctangent of the x and y coordinates specified by expression1 and expression2.

Example

select atan2 (1,1) * (180/ pi()) 'Arctangent in degrees' from syscalctable;

ARCTANGENT IN DE

----------------

45.000000000000000

1 record selected

select atan2 (1,1) 'Arctangent in radians' from syscalctable;

ARCTANGENT IN RA

----------------

0.785398163397448

1 record selected

Notes

ATAN2 takes the ratio of two sides of a right triangle and returns the corresponding angle. The ratio is the length of the side opposite the angle divided by the length of the side adjacent to the angle.

expression1 and expression2 specify the x and y coordinates of the end of the hypotenuse opposite the angle.

The result is expressed in radians and is in the range -Pi/2 to Pi/2 radians. To convert degrees to radians, multiply degrees by Pi/180. To convert radians to degrees, multiply radians by 180/Pi.

Both expression1 and expression2 must evaluate to approximate numeric data types.

TOCIndex