THE WORLD'S LARGEST WEB DEVELOPER SITE

SQL Server CAST() Function

❮ SQL Server Functions

Example

Convert an expression from one data type to another (integer):

SELECT CAST(25.65 AS int);
Try it Yourself »

Definition and Usage

The CAST() function converts an expression from one data type to another data type.

Note: When converting from a float or numeric to an integer, the CAST() function will truncate the result. For other conversions, the CAST() function will round the result.

Tip: See also the CONVERT() function.

Syntax

CAST(expression AS data_type(length))

Parameter Values

Value Description
expression Required. The value to convert to another data type
data_type Required. The datatype to convert expression to. Can be one of the following: bigint, int, smallint, tinyint, bit, decimal, numeric, money, smallmoney, float, real, datetime, smalldatetime, char, varchar, text, nchar, nvarchar, ntext, binary, varbinary, or image
(length) Optional. The length of the resulting data type (for char, varchar, nchar, nvarchar, binary and varbinary)

Technical Details

Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

More Examples

Example

Convert an expression from one data type to another (varchar):

SELECT CAST(25.65 AS varchar);
Try it Yourself »

Example

Convert an expression from one data type to another (datetime):

SELECT CAST('2017-08-25' AS datetime);
Try it Yourself »

❮ SQL Server Functions