Arithmetical operators on time queries

InfluxDB 2
, , , ,
1

Would it be possible to perform mathematical operations in queries on now()?
For example “… WHERE time > math.round(now()/96)”

2

Hello @ricrug,
Welcome!
Yes you can use the toUint() or uint() function first to convert the time or duration data so that you can divide:

Oh snap you’re using 1.x and influxql…hmm I don’t think these functions exist in influxql.