tan-transact-sql.md

title	TAN (Transact-SQL)
description	TAN (Transact-SQL)
author	MikeRayMSFT
ms.author	mikeray
ms.date	03/03/2017
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
ms.custom	ignite-2025
f1_keywords	TAN_TSQL TAN
helpviewer_keywords	TAN function tangent
dev_langs	TSQL
monikerRange	>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric || =fabric-sqldb

TAN (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb]

Returns the tangent of the input expression.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

TAN ( float_expression )  

Arguments

float_expression
Is an expression 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);  

[!INCLUDEssResult]

----------------------  
1.6331778728383844E+16  

Examples: [!INCLUDEssazuresynapse-md] and [!INCLUDEssPDW]

The following example returns the tangent of .45.

SELECT TAN(.45);  

[!INCLUDEssResult]

--------  
0.48

See Also

Mathematical Functions (Transact-SQL)