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' 

 

posted @ 2018-01-11 15:47  panie2015  阅读(606)  评论(0编辑  收藏  举报