--- title: "RADIANS (Transact-SQL)" description: "RADIANS (Transact-SQL)" author: MikeRayMSFT ms.author: mikeray ms.date: "03/13/2017" ms.service: sql ms.subservice: t-sql ms.topic: reference f1_keywords: - "RADIANS" - "RADIANS_TSQL" helpviewer_keywords: - "RADIANS function" dev_langs: - "TSQL" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current||=fabric" --- # RADIANS (Transact-SQL) [!INCLUDE [sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw.md)] Returns radians when a numeric expression, in degrees, is entered. :::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: [Transact-SQL syntax conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md) ## Syntax ```syntaxsql RADIANS ( numeric_expression ) ``` [!INCLUDE[sql-server-tsql-previous-offline-documentation](../../includes/sql-server-tsql-previous-offline-documentation.md)] ## Arguments *numeric_expression* Is an [expression](../../t-sql/language-elements/expressions-transact-sql.md) 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. ```sql SELECT RADIANS(1e-307) GO ``` [!INCLUDE[ssResult](../../includes/ssresult-md.md)] ``` ------------------- 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. ```sql -- 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 ``` [!INCLUDE[ssResult](../../includes/ssresult-md.md)] ``` --------------------------------------- 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)](../../t-sql/functions/cast-and-convert-transact-sql.md) [decimal and numeric (Transact-SQL)](../../t-sql/data-types/decimal-and-numeric-transact-sql.md) [float and real (Transact-SQL)](../../t-sql/data-types/float-and-real-transact-sql.md) [int, bigint, smallint, and tinyint (Transact-SQL)](../../t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql.md) [Mathematical Functions (Transact-SQL)](../../t-sql/functions/mathematical-functions-transact-sql.md) [money and smallmoney (Transact-SQL)](../../t-sql/data-types/money-and-smallmoney-transact-sql.md)