GBase 8a集群支持毫秒的字段类型

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>

发表评论

您的电子邮箱地址不会被公开。