Arithmetical operators on time queries

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

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:
https://docs.influxdata.com/influxdb/v2.0/reference/flux/stdlib/built-in/transformations/type-conversions/touint/
https://docs.influxdata.com/influxdb/v2.0/reference/flux/stdlib/built-in/transformations/type-conversions/uint/

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