SQL CONVERT Function

SQL CONVERT Function

The SQL CONVERT function is used to change the data type of a value to another data type. It is commonly used to convert between numeric, string, and date/time values. The CONVERT function provides more formatting options than CAST, making it useful for specific output formats.

In this tutorial, we will explore the SQL CONVERT function, its syntax, and practical examples demonstrating how to use it effectively.

---

Syntax of SQL CONVERT Function

The basic syntax of the CONVERT function is:

CONVERT(data_type(length), expression, style)

Parameters:

• data_type(length): The target data type to which the expression is converted.
• expression: The value or column that needs to be converted.
• style: (Optional) Used when converting date/time values to different formats.

---

Step-by-Step Examples Using SQL CONVERT

1 Converting Date to a String Format

Let’s create an employees table and insert some sample data:

In SQL Server:

CREATE TABLE employees (
    id INT PRIMARY KEY IDENTITY(1,1),
    name VARCHAR(50),
    joining_date DATETIME
);

Insert some sample data:

INSERT INTO employees (name, joining_date)
VALUES 
('Arjun', '2024-02-01 10:30:00'),
('Ram', '2023-08-15 09:00:00'),
('Priya', '2022-12-10 15:45:00');

Now, let’s use CONVERT to display the joining date in a different format:

SELECT name, 
       joining_date, 
       CONVERT(VARCHAR, joining_date, 103) AS formatted_date
FROM employees;