Export (0) Print
Expand All
ABS
ALL
AND
ANY
AVG
bit
COS
COT
DAY
EXP
GO
IN
LEN
LOG
MAX
MIN
NOT
OR
PI
SET
SIN
STR
SUM
TAN
USE
VAR
Expand Minimize

RADIANS

SQL Server 2000

Returns radians when a numeric expression, in degrees, is entered.

Syntax

RADIANS ( numeric_expression )

Arguments

numeric_expression

Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.

Return Types

Returns the same type as numeric_expression.

Examples
A. Use RADIANS to show 0.0

This example returns a result of 0.0 because the numeric expression to convert to radians is too small for the RADIANS function.

SELECT RADIANS(1e-307)
GO

Here is the result set:

------------------- 
0.0                      
(1 row(s) affected)
B. Use RADIANS

This example takes a float expression and returns the RADIANS of the given angle.

-- First value is -45.01.
DECLARE @angle float
SET @angle = -45.01
SELECT 'The RADIANS of the angle is: ' +
   CONVERT(varchar, RADIANS(@angle))
GO
-- Next value is -181.01.
DECLARE @angle float
SET @angle = -181.01
SELECT 'The RADIANS of the angle is: ' +
   CONVERT(varchar, RADIANS(@angle))
GO
-- Next value is 0.00.
DECLARE @angle float
SET @angle = 0.00
SELECT 'The RADIANS of the angle is: ' +
   CONVERT(varchar, RADIANS(@angle))
GO
-- Next value is 0.1472738.
DECLARE @angle float
SET @angle = 0.1472738
SELECT 'The RADIANS of the angle is: ' +
    CONVERT(varchar, RADIANS(@angle))
GO
-- Last value is 197.1099392.
DECLARE @angle float
SET @angle = 197.1099392
SELECT 'The RADIANS of the angle is: ' +
   CONVERT(varchar, RADIANS(@angle))
GO

Here is the result set:

--------------------------------------- 
The RADIANS of the angle is: -0.785573                      
(1 row(s) affected)
--------------------------------------- 
The RADIANS of the angle is: -3.15922                       
(1 row(s) affected)
--------------------------------------- 
The RADIANS of the angle is: 0                              
(1 row(s) affected)
--------------------------------------- 
The RADIANS of the angle is: 0.00257041                     
 (1 row(s) affected)
--------------------------------------- 
The RADIANS of the angle is: 3.44022                        
(1 row(s) affected)

See Also

CAST and CONVERT

decimal and numeric

float and real

int, smallint, and tinyint

Mathematical Functions

money and smallmoney

Show:
© 2014 Microsoft