--- title: "TAN (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/03/2017" ms.prod: "sql-non-specified" ms.reviewer: "" ms.suite: "" ms.technology: - "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords: - "TAN_TSQL" - "TAN" dev_langs: - "TSQL" helpviewer_keywords: - "TAN function" - "tangent" ms.assetid: f679fa6a-5739-484b-9450-fb3400d4f30c caps.latest.revision: 22 author: "BYHAM" ms.author: "rickbyh" manager: "jhubbard" --- # TAN (Transact-SQL) [!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)] Returns the tangent of the input expression. ![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 TAN ( float_expression ) ``` ## Arguments *float_expression* Is an [expression](../../t-sql/language-elements/expressions-transact-sql.md) of type **float** or of a type that can be implicitly converted to **float**, interpreted as number of radians. ## Return Types **float** ## Examples The following example returns the tangent of `PI()/2`. ``` SELECT TAN(PI()/2); ``` [!INCLUDE[ssResult](../../includes/ssresult-md.md)] ``` ---------------------- 1.6331778728383844E+16 ``` ## Examples: [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)] The following example returns the tangent of .45. ``` SELECT TAN(.45); ``` [!INCLUDE[ssResult](../../includes/ssresult-md.md)] `--------` `0.48` ## See Also [Mathematical Functions (Transact-SQL)](../../t-sql/functions/mathematical-functions-transact-sql.md)