CREATE DATABASE test; use test; CREATE TABLE dates( id int PRIMARY KEY AUTO_INCREMENT, date_col DATE );
INSERT INTO dates(date_col) VALUES ('2023-12-26'), ('2024-01-20');
select id,date_col, UNIX_TIMESTAMP(date_col) AS timestamp_col FROM dates;