--- title: "RADIANS (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/13/2017" ms.prod: "sql-non-specified" ms.reviewer: "" ms.suite: "" ms.technology: - "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords: - "RADIANS" - "RADIANS_TSQL" dev_langs: - "TSQL" helpviewer_keywords: - "RADIANS function" ms.assetid: e9f69951-ecda-45d9-8909-dcb716b1b1c0 caps.latest.revision: 23 author: "BYHAM" ms.author: "rickbyh" manager: "jhubbard" --- # RADIANS (Transact-SQL) [!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)] Returns radians when a numeric expression, in degrees, is entered. ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md) ## Syntax ``` -- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse RADIANS ( numeric_expression ) ``` ## Arguments *numeric_expression* Is an [expression](../../t-sql/language-elements/expressions-transact-sql.md) 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. 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 ``` [!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. ``` -- 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) ``` ## Examples: [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)] ### C. 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 ``` [!INCLUDE[ssResult](../../includes/ssresult-md.md)] ``` ------------------- 0.0 (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)