MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.36

CREATE TABLE concertlistts (
    date VARCHAR(8)
);
INSERT INTO concertlistts (date) VALUES
    ('25/12/24'),
    ('01/01/25'),
    ('25/03/25');

Records: 3  Duplicates: 0  Warnings: 0

SELECT STR_TO_DATE(c.date, '%d/%m/%y') AS parsed_date
FROM concertlistts AS c;

parsed_date

2024-12-25

2025-01-01

2025-03-25