SQL Tutorial SQL Advanced SQL Database SQL References

SQL Server - COS() Function



The SQL Server (Transact-SQL) COS() function returns trigonometric cosine of an angle (angle should be in radians).

Syntax

COS(x)

Parameters

x Required. Specify the angle in radian.

Return Value

Returns the trigonometric cosine of an angle.

Example 1:

The example below shows the usage of COS() function.

SELECT COS(0);
Result: 1.0

SELECT COS(1);
Result: 0.54030230586813965

SELECT COS(-1);
Result: 0.54030230586813965

SELECT COS(2);
Result: -0.41614683654714241

SELECT COS(-2);
Result: -0.41614683654714241

SELECT COS(PI());
Result: -1.0

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 1-10
Data 2-5
Data 30
Data 45
Data 510

The query given below can be used to calculate the trigonometric cosine value of column x.

SELECT *, COS(x) AS COS_Value FROM Sample;

This will produce the result as shown below:

DataxCOS_Value
Data 1-10-0.83907152907645244
Data 2-50.28366218546322625
Data 301.0
Data 450.28366218546322625
Data 510-0.83907152907645244

❮ SQL Server Functions

5