Skip to content
Related Articles

Related Articles

SIN() and COS() Function in SQL Server
  • Last Updated : 29 Sep, 2020

1. SIN() Function :
The SIN() function returns the sine of a number.

Syntax :

SIN(number)

Parameter : Required. A numeric value.
number : It is a numeric value.
Returns : It returns the float_expression of the sine of a number.

Example-1 :
When the argument holds a positive number.

SELECT SIN(5);

Output :



-0.95892427466313845



Example-2 :
When the argument holds a negative number.

SELECT SIN(-5);

Output :

0.95892427466313845



Example-3 :
When the PI() function is the argument.

SELECT SIN(PI());

Output :

1.2246467991473532E-16



Example-4 :
When the argument passed is an expression.

SELECT SIN(4 * 3);

Output :

-0.53657291800043494


2. COS() Function
The COS() function returns the cosine of a number.



Syntax :

COS(number)

Parameter : Required. A numeric value.
number : It is a numeric value.
Returns : It returns the cosine of a number.

Example-1 :
When the argument holds a positive number.

SELECT COS(4);

Output :

-0.65364362086361194



Example-2 :
When the argument is a fractional component.

SELECT COS(2.53);

Output :

-0.81873459927738157



Example-3 :
When the PI() function is the argument.

SELECT COS(PI());

Output :

-1
My Personal Notes arrow_drop_up
Recommended Articles
Page :