Purpose
The SIN function returns the sine of an angle specified by the x argument. The return value is in the range [-1, 1].
Syntax
SIN(x)
Parameters
x is a numeric data type or a parameter that can be implicitly converted to a numeric data type. The value of x is an angle in radians.
Return type
If the data type of parameter x is BINARY_FLOAT, the function returns a value of the BINARY_DOUBLE data type. Otherwise, the function returns a value of the same numeric data type as parameter x.
Examples
Return the sine values of angles of 0 degrees and 30 degrees.
obclient> SELECT SIN(0),SIN(30*3.14159265/180) FROM DUAL;
+--------+-------------------------------------------+
| SIN(0) | SIN(30*3.14159265/180) |
+--------+-------------------------------------------+
| 0 | .4999999994818579767701332168843926496529 |
+--------+-------------------------------------------+
1 row in set