CAST Function
In many cases, a database will automatically convert one data type
into another when needed. On the other hand, there are instances when that is
not the case, or when you want to explicitly specify what data type to change
into. In these cases, you can use the CAST function. The syntax of
the CAST function is as follows:
CAST (expression AS [data type])
where [data type] is a valid data type in the RDBMS you are
working with.
Table Student
|
StudentID
|
First_Name
|
Marks
|
|
1
|
Anil
|
95.9
|
|
2
|
Sunil
|
93.5
|
|
3
|
Ram
|
80
|
|
4
|
sumit
|
70.1
|
Example
SELECT First_Name, CAST(Marks AS Integer) marks FROM Student_Score;
OutPut:
|
First_Name
|
Int_Marks
|
|
Anil
|
96
|
|
Sunil
|
94
|
|
Ram
|
80
|
|
sumit
|
70
|
