The Cast() Function is used to change the data type of a column. We can use the cast() function for various purpose.
Cast(Original_Expression as Desired_DataType)
We can use this function for the following purpose:
1. To concatenate string 2.. Joining two columns 3. Performing Unions of Table 4. Performing mathematical operation on columns
Example:Â For example we have an employee Table
Now we execute the following query to use Cast() Function.
Select Name, WorkingHours = Cast(WorkingHours as char(2)) + 'hours working a day' From Employee
The Convert() Function is used to convert a date/time value in different different formats. Click here to learn more