By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table datess(
y int,
m varchar(3),
d int,
t varchar(5));
insert into datess (y,m,d,t)values
(2022 ,'May', 20 ,'18:43'),
(1982 ,'Feb', 01 ,'00:23'),
(1942 ,'Jan', 13 ,'16:17');
SELECT
STR_TO_DATE(
CONCAT(y,'-',m,'-',d,' ',t),
'%Y-%M-%d %H:%i') date_format
FROM datess;
| date_format |
|---|
| 2022-05-20 18:43:00 |
| 1982-02-01 00:23:00 |
| 1942-01-13 16:17:00 |