I have a data base that logs the water meter. Every 30 seconds the database will get a new value of the water meter. Now I want to get the daily consumed water. I managed to do that with the following query:
The problem I have is that the time column starts at 8:00 pm. It measures the consumption from 8 pm to 8pm the next day. I Would like to set it so it measure from 0:00 to 23:59.
Can somebody help me?