SQL - CONVERSION
SQL - Conversion Functions
Definition
Conversion Functions in SQL are used to convert a value from one data type to another. They help ensure data compatibility and proper formatting during data processing.
SQL Queries Using CAST() and CONVERT() on Employee Table
1. Convert Salary to Integer Using CAST()
SELECT EmpName,
CAST(Salary AS INT) AS Salary_Int
FROM Employee;
2. Convert Employee ID to Character Using CAST()
SELECT CAST(EmpID AS CHAR) AS Employee_ID
FROM Employee;
3. Convert Join Date to Date Format Using CAST()
SELECT EmpName,
CAST(JoinDate AS DATE) AS Joining_Date
FROM Employee;
4. Convert Salary to Integer Using CONVERT()
SELECT EmpName,
CONVERT(INT, Salary) AS Salary_Int
FROM Employee;