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

SIGN() Function in SQL Server

sanjoy_62

Improve

Article Tags :

Similar Reads

TAN() and COT() Function in SQL Server

1. TAN() Function : The TAN() function returns the tangent of a number. Syntax : TAN(number) Parameter : Required. A numeric value. number : It is a numeric value. Returns : It returns the float_expression of the tangent of a number. Example-1 : When the arguments holds a positive number. SELECT TAN

2 min read

SIGN() Function in SQL Server

In SQL Server, the SIGN() function is a mathematical function used to determine the sign of a given numeric expression. This function is particularly useful when we want to evaluate whether a number is positive, negative or zero. In this article, We will learn about SIGN() Function in SQL Server in

3 min read

ATN2() Function in SQL Server

In this article, we are going to cover the ATN2()function in which we will see how we can get the arc tangent of two given numbers. Let's discuss one by one. // here val1 and val2 are input. Input : ATN2(val1, val2) Output : Arc tangent result. ATN2() : It is the function that returns the arc tangen

1 min read

COUNT() Function in SQL Server

The COUNT() function in SQL Server is a fundamental aggregate function used to determine the number of rows that match a specific condition. Counting rows provides valuable insights into data sets such as the total number of records, distinct values, or records meeting certain criteria. In this arti

3 min read

ASCII() Function in SQL Server

The ASCII() function returns the ASCII value of the leftmost character of a character expression. Syntax : ASCII(character_expression) Parameter : This method accepts a single-parameter as mentioned above and described below : character_expression : It can be a literal character, an expression of a

2 min read

DAY() Function in SQL Server

DAY() function : This function in SQL Server is used to return the day of the month i.e, from 1st to 31st for date stated. Features : This function is used to find the day of the month for a date specified. This function comes under Date Functions. This function accepts only one parameter i.e, date.

2 min read

SIN() and COS() Function in MySQL

1. SIN() Function : SIN() function in MySQL is used to return the sine of any given number X, where X is given in radians. Syntax : SIN(X) Parameter : Required. X : A number whose sine value we want to calculate. It is given in radian. Returns : It returns the sine of given number x. Example-1 : Sin

2 min read

FLOOR() and CEILING() Function in SQL Server

1. FLOOR() Function : The FLOOR() function returns the largest integer value which is less than or equal to a number. Syntax : FLOOR(number) Parameter : Required. A numeric value. number : It is a numeric value. Returns : It returns the integer value. Example-1 : When the argument holds a positive n

1 min read

DATEADD() Function in SQL Server

DATEADD() function : This function in SQL Server is used to sum up a time or a date interval to a specified date, then returns the modified date. Features : This function is used to sum up a time or a date interval to a date specified. This function comes under Date Functions. This function accepts

3 min read

DATENAME() Function in SQL Server

DATENAME() function : This function in SQL Server is used to find a given part of the specified date. Moreover, it returns the output value as a string. Features : This function is used to find a given part of the specified date.This function comes under Date Functions.This function accepts two para

2 min read