MySQL 8.0

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

select version();

version()

8.0.30

create table t as
  select curdate() as dt;

Records: 1  Duplicates: 0  Warnings: 0

show create table t;

Table
Create Table

t
CREATE TABLE `t` (
  `dt` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci