捣鼓了半天
终于发现influxdb只能识别一种时间格式:2021-09-07 16:58:17
2021/09/07 16:58:17或者是2021-9-7 16:58:17都不行。
下面是我influxdb的查询语句
SELECT * FROM "modbus" WHERE time >= '2021-09-07 16:58:17' AND time < '2021-09-07 17:03:17' group by "name" order by "time" asc
下面是我C#请求influxdb的语句,包括转义符乱七八糟的。
influxDBHelper.Query($"SELECT time,zll%2Bssll,\"name\" FROM \"modbus\" WHERE time >= '{nowTime.AddMinutes(-5).ToString("yyyy-MM-dd HH:mm:ss")}' AND time <'{nowTime.ToString("yyyy-MM-dd HH:mm:ss")}' group by \"name\" order by \"time\" asc", item)