SELECT HISTOGRAM(CAST(statTime AS DATE), INTERVAL 1 DAY) AS h, COUNT(*) FROM \"aaa\" group by h
结果:
[
"2020-05-25T00:00:00.000Z",
16
],
[
"2020-06-12T00:00:00.000Z",
8
]
需要怎么格式化才能得到如下结果???
期望结果:
[
"2020-05-25 00:00:00",
16
],
[
"2020-06-12 00:00:00",
8
],
结果:
[
"2020-05-25T00:00:00.000Z",
16
],
[
"2020-06-12T00:00:00.000Z",
8
]
需要怎么格式化才能得到如下结果???
期望结果:
[
"2020-05-25 00:00:00",
16
],
[
"2020-06-12 00:00:00",
8
],
0 个回复