To_char SQL

Why To_char SQL is important

-- Sample table
CREATE TABLE employees (
    employee_id NUMBER,
    first_name VARCHAR2(50),
    hire_date DATE,
    salary NUMBER
);

-- Insert some sample data
INSERT INTO employees (employee_id, first_name, hire_date, salary)
VALUES
(1, 'John', DATE '2023-05-15', 60000),
(2, 'Jane', DATE '2022-10-20', 75000);

-- Format the hire date as 'Month DD, YYYY'
SELECT
    employee_id,
    first_name,
    to_char(hire_date, 'Month DD, YYYY') AS formatted_hire_date,
    salary
FROM
employees;

-- Format the salary with a currency symbol and comma as thousands separator
SELECT
    employee_id,
    first_name,
    to_char(salary, '$999,999.99') AS formatted_salary
FROM
employees;

-- Format a number as a percentage
SELECT
    to_char(0.85, '99.99%') AS percentage
FROM dual;

-- Clean up
DROP TABLE employees;