title: "TAN (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/03/2017" ms.prod: sql ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.component: "t-sql|functions" ms.reviewer: "" ms.suite: "sql" ms.technology: t-sql 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: edmacauley ms.author: edmaca manager: craigg monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-all-md]
Returns the tangent of the input expression.
Transact-SQL Syntax Conventions
TAN ( float_expression )
float_expression
Is an expression of type float or of a type that can be implicitly converted to float, interpreted as number of radians.
float
The following example returns the tangent of PI()/2.
SELECT TAN(PI()/2);
[!INCLUDEssResult]
----------------------
1.6331778728383844E+16
The following example returns the tangent of .45.
SELECT TAN(.45);
[!INCLUDEssResult]
--------
0.48