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位