mysql-datetime(0) 后面数字问题

mysql-datetime(0) 后面数字问题

直接创建表:

CREATE TABLE `flink-db`.`Untitled`  (
  `id` int NOT NULL COMMENT 'id',
  `time0` datetime NULL,
  `time3` datetime(3) NULL,
  `time6` datetime(6) NULL,
  `time8` datetime(8) NULL,
  PRIMARY KEY (`id`)
);

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-y5ekOjcn-1692061557282)(C:\Users\xiaodong.zheng\AppData\Roaming\Typora\typora-user-images\image-20230814184749095.png)]

看插入值:

mysql> SELECT * FROM `t_time_test`;
+----+---------------------+-------------------------+----------------------------+
| id | time0               | time3                   | time6                      |
+----+---------------------+-------------------------+----------------------------+
|  1 | 2023-08-14 18:48:36 | 2023-08-14 18:48:38.000 | 2023-08-14 18:48:40.000000 |
|  2 | 2023-08-14 18:49:27 | 2023-08-14 18:49:31.000 | 2023-08-14 18:49:35.000000 |
+----+---------------------+-------------------------+----------------------------+

发现 datetime(N), N 有几位，精度就到几位，但不能超过 6位