APPX Software Library

Chapter 4: SQL Language Elements

4.9.2.19 COS function (ODBC compatible)

Syntax

COS ( expression )

Description

The scalar function COS returns the cosine of expression.

Example

select cos(45 * pi()/180) 'Cosine of 45 degrees' from syscalctable;
COSINE OF 45 DEG
----------------
0.707106781186548
1 record selected

Notes

COS takes an angle (expression) and returns the ratio of two sides of a right triangle. The ratio is the length of the side adjacent to the angle divided by the length of the hypotenuse.

  • expression specifies an angle in radians
  • expression must evaluate to an approximate numeric data type.

To convert degrees to radians, multiply degrees by Pi/180. To convert radians to degrees, multiply radians by 180/Pi.