GBase 8a集群支持毫秒的字段类型只有datetime类型支持毫秒,6位。 其它的date,timestamp都不支持
如下是测试结果
gbase> create table t_ms(a date,b datetime,c timestamp); Query OK, 0 rows affected (Elapsed: 00:00:00.46) gbase> insert into t_ms values ('2020-03-08 12:13:14.123456','2020-03-08 12:13:14.234567','2020-03-08 12:13:14.345678'); Query OK, 1 row affected, 1 warning (Elapsed: 00:00:00.10) gbase> show warnings; +-------+------+----------------------------------------+ | Level | Code | Message | +-------+------+----------------------------------------+ | Note | 1265 | Data truncated for column 'a' at row 1 | +-------+------+----------------------------------------+ 1 row in set (Elapsed: 00:00:00.00) gbase> select * from t_ms; +------------+----------------------------+---------------------+ | a | b | c | +------------+----------------------------+---------------------+ | 2020-03-08 | 2020-03-08 12:13:14.234567 | 2020-03-08 12:13:14 | +------------+----------------------------+---------------------+ 1 row in set (Elapsed: 00:00:00.30) gbase>