-- SELECT * FROM test.test2_cs;


CREATE TABLE `test2_cs` (
  `id` int(11) NOT NULL,
  `date_string` varchar(45) DEFAULT NULL,
  `date_date` date DEFAULT NULL,
  `date_datetime` datetime DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;

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

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