SQL Server CAST() Function
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 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 |
|---|
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 »
