SQL Reference

Returns the arctangent of expression.

ATAN ( expression ) |

The expression must be in the range -1 to 1.

The expression must evaluate to an approximate numeric data type.

The following example illustrates two ways to use the ATAN function:

select atan (1) * (180/ pi()) 'Arctangent in degrees' from syscalctable; ARCTANGENT IN DEGREES ----------------------- 45.000000000000000 1 record selected select atan (1) 'Arctangent in radians' from syscalctable; ARCTANGENT IN RADIANS ----------------------- 0.785398163397448 1 record selected |

ATAN takes the ratio (expression) 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.

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.

ODBC compatible

© 2017 Progress Software Corporation and/or one of its subsidiaries or affiliates. All rights reserved.

Progress® OpenEdge® Release 11.7