如何计算DATETIME类型和TIMESTAMP类型的差值，想计算平均延迟
GUI脚本
t =table(
array(DATETIME, 0) as MDTime,
array(TIMESTAMP, 0) as ReceivedTime
)
share t as testShareTable;
select * from testShareTable;
select avg(ReceivedTime - MDTime) as DelayTime from testShareTable;
表记录如下
计算结果如下
结果异常。
另外，如何将ReceivedTime列加上8小时？
最佳答案 2022-01-07 16:29
select avg(temporalAdd(ReceivedTime,8H) - timestamp(MDTime)) as DelayTime from testShareTable;
