github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/datetimetable (about)

     1  exec
     2  CREATE TABLE `datetime_table` (
     3    `i` bigint NOT NULL,
     4    `date_col` date,
     5    `datetime_col` datetime,
     6    `timestamp_col` timestamp,
     7    `time_col` time(6),
     8    PRIMARY KEY (`i`)
     9  )
    10  ----
    11  
    12  exec
    13  insert into datetime_table values
    14      (1, '2019-12-31T12:00:00Z', '2020-01-01T12:00:00Z', '2020-01-02T12:00:00Z', '03:10:0'),
    15      (2, '2020-01-03T12:00:00Z', '2020-01-04T12:00:00Z', '2020-01-05T12:00:00Z', '04:00:44'),
    16      (3, '2020-01-07T00:00:00Z', '2020-01-07T12:00:00Z', '2020-01-07T12:00:01Z', '15:00:00.005000')
    17  ----
    18  
    19  exec
    20  create index datetime_table_d on datetime_table (date_col)
    21  ----
    22  
    23  exec
    24  create index datetime_table_dt on datetime_table (datetime_col)
    25  ----
    26  
    27  exec
    28  create index datetime_table_ts on datetime_table (timestamp_col)
    29  ----