CAST and CONVERT (Transact-SQL) - SQL Server

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric These functions convert an expression of one data type to another. Syntax CAST syntax: CAST ( expression AS data_type [ ( length ) ] ) CONVERT syntax: CONVERT ( data_type [ ( length ) ] , expression [ ,