Chapter 4: SQL Language Elements
4.9.2.74 SIN function (ODBC compatible)
Syntax
SIN ( expression )
Description
The scalar function SIN returns the sine of expression.
Example
select sin(45 * pi()/180) 'Sine of 45 degrees' from syscalctable; SINE OF 45 DEGRE ---------------- 0.707106781186547 1 record selected
Notes
SIN takes an angle (expression) and returns the ratio of two sides of a right triangle. The ratio is the length of the side opposite 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.