Purpose
You can call this function to return the sine of an angle. The return value is in the range of [-1, 1].
Syntax
SIN(x)
Parameters
x is of a numeric data type whose value can be any real number (an angle expressed in radians), or is of any data type that can be implicitly converted to a numeric data type.
Return type
If x is of the BINARY_FLOAT data type, the return type is BINARY_DOUBLE. Otherwise, the return type is a numeric data type same as that of x.
Examples
The following example returns the sines 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