SQL Server CAST() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
SQL Server CAST() Function
❮ SQL Server Functions
Example
Convert a value to an int datatype:
SELECT CAST(25.65 AS int);Try it Yourself »
Definition and Usage
The CAST() function converts a value (of any type) into a specified datatype.
Tip: Also look at the
CONVERT() function.
Syntax
CAST(expression
AS datatype(length))Parameter Values
| Value | Description |
|---|---|
| expression | Required. The value to convert |
| datatype | 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 a value to a varchar datatype:
SELECT CAST(25.65 AS varchar);Try it Yourself »
Example
Convert a value to a datetime datatype:
SELECT CAST('2017-08-25' AS datetime);Try it Yourself »
❮ SQL Server Functions
