PISQLDAS 查询语句

SELECT tag,CAST(value AS Float64) FROM piarchive..piavg WHERE tag = ? AND time >= DATE(?) AND time < DATE(?) AND timestep = TIME(?)

 

查询 两个时间之间 每隔一分钟的 所有数据

SELECT tag, time, value, status FROM piarchive..piinterp WHERE status=0 and tag = 'cdt158' and timestep = TIME('1m') and time BETWEEN '2018-01-11 10:57:58' AND '2018-01-11 11:57:58' 

 

转载于:https://www.cnblogs.com/panie2015/p/8268800.html