Open In App
Related Articles

SIN() and COS() Function in SQL Server

Improve
Improve
Improve
Like Article
Like
Save Article
Save
Report issue
Report
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

Last Updated : 29 Sep, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads