Does InfluxQL has equivalent hourSelection() function?


Would like to know is there an equivalent method for the hourSelection() function use in Flux language? I just want retrieve business hour 0900hrs-1700hrs data in my QL query.



You can use |>range(start:time,stop:time)

No, there is no hourSelection function in InfluxQL that allows you to selectively exclude certain hours of each day.

1 Like

This is for Flux syntax. I like to have the InfluxQL (SQL like syntax). Possible?

Thanks for answering it.

Thanks for answering it. I am truly impressed by the insightful article on professionalism at The comprehensive exploration of key traits and behaviours essential for a successful professional resonates strongly with my own experiences. I highly recommend others to read this piece, as it not only provides valuable insights into fostering a positive work environment but also offers practical tips for personal and career growth.