sine function

The sin function is a trigonometric function. The sin function returns the sine of an angle specified in radians.

Syntax:

double sin(n)

Semantics:

  • n: The argument n is an expression that resolves to a number (an angle expressed in radians).
  • return type: double.

    The resultant value is in the range -1 through 1 with the following exceptions:

    • Returns a NULL value in the following cases:
      • n resolves to a NULL value
      • n does not resolve to a number
    • Returns NaN if n resolves to NaN or infinity(positive/negative).
    • Returns a zero if n resolves to a positive/negative zero.
Example:
SELECT sin(n) FROM Archery
Value of n Output
radians(90) 1.0
pi()/4 0.7071067811865475
3*pi()/2 -1.0