By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE SampleDates (
Date VARCHAR(10) -- Assuming the date format is MM/DD/YYYY
);
INSERT INTO SampleDates (Date)
VALUES
('1/20/2024'),
('1/21/2024'),
('1/26/2024'),
('2/1/2024'),
('2/2/2024'),
('2/2/2024');
Records: 6 Duplicates: 0 Warnings: 0
SELECT
Date,
DATE_FORMAT(STR_TO_DATE(Date, '%m/%d/%Y'), '%b') AS Month
FROM
SampleDates;
| Date | Month |
|---|---|
| 1/20/2024 | Jan |
| 1/21/2024 | Jan |
| 1/26/2024 | Jan |
| 2/1/2024 | Feb |
| 2/2/2024 | Feb |
| 2/2/2024 | Feb |