GBase 8a MPP Cluster 的datetime的精度

GBase 8a MPP Cluster的datetime类型支持6位毫秒

语法如下：

gbase> create table t1(a datetime);

Query OK, 0 rows affected (Elapsed: 00:00:00.05)

gbase> insert into t1 values('9999-12-31 23:59:59.000123');

Query OK, 1 row affected (Elapsed: 00:00:00.04)

gbase> select date_format(a,'%Y-%m-%d %H:%i:%s.%f') from t1;

+---------------------------------------+

| date_format(a,'%Y-%m-%d %H:%i:%s.%f') |

+---------------------------------------+

| 9999-12-31 23:59:59.000000            |

| 9999-12-31 23:59:59.000123            |

+---------------------------------------+

2 rows in set (Elapsed: 00:00:00.01)