SQL CAST Function
The SQL CAST function is mainly used to convert the expression from one data type to another data type. If the SQL Server CAST function is unable to convert a declaration to the desired data type, this function returns an error. We use the CAST function to convert numeric data into character or string data.
Here, the [data type] is a type of valid data types in RDBMS.
The syntax is:
By default, it is 30.
Here, we will use the below tables.
Table Manager _ Score
The table contains the following rows:
In Example 1, we are using the CAST function to convert the SCORE column from type FLOAT to INTEGER. When we do it, various RDBMS have many rules to handle the numbers to the point of decimal.
According to the above example, the numbers after the decimal point are truncated.
In Example 2, we use the CAST function to convert the SCORE column from type FLOAT to CHAR (3). When we do it, we only hold the first 3 character. If there are more than three characters, everything after the first three characters is discarded.