版本2.0.9,doris日期精度想保留到微秒,插入表中的数据是【2024-12-30 15:13:16.014】
显示的结果却是【2024-12-30 15:13:16.0】。
建表语句:
CREATE TABLE odstest (
id INT,
time1 datetime,
time2 DATETIME(6)
) ENGINE=OLAP
UNIQUE KEY(`id`)
COMMENT ''
DISTRIBUTED BY HASH(`id`) BUCKETS 20
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"is_being_synced" = "false",
"storage_format" = "V2",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);
插入语句:
insert into odstest select 8,'2024-12-30 15:13:16.014','2024-12-30 15:13:16.014'
查询结果显示: