RADIANS (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
Returns radians when a numeric expression, in degrees, is entered.
Transact-SQL syntax conventions
Syntax
RADIANS ( numeric_expression )
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
numeric_expression
Is an expression of the exact numeric or approximate numeric data type category.
Return Types
The return type depends on the input type of numeric_expression:
Input type | Return type |
---|---|
float, real | float |
decimal(p, s) | decimal(38, s) |
int, smallint, tinyint | int |
bigint | bigint |
money, smallmoney | money |
bit | float |
If the result does not fit in the return type, an arithmetic overflow error occurs.
Examples
A. Using RADIANS to show 0.0
The following 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. Using RADIANS to return the equivalent angle of a float expression.
The following example takes a float
expression and returns the RADIANS
of the specified 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 (Transact-SQL)
decimal and numeric (Transact-SQL)
float and real (Transact-SQL)
int, bigint, smallint, and tinyint (Transact-SQL)
Mathematical Functions (Transact-SQL)
money and smallmoney (Transact-SQL)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho