-- SELECT * FROM test.test1;

CREATE TABLE `test1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_string` varchar(45) CHARACTER SET latin1 DEFAULT NULL,
  `date_date` date DEFAULT NULL,
  `date_datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;


insert into test.test1(date_string, date_date,date_datetime) values ('2022-10-10 15:45:15', date(now()), now());

set lc_time_names='es_ES';
select monthname(date_string) from test.test1;
select monthname(date_date) from test.test1;
select monthname(date_datetime) from test.test1;