Re: Downsampliing data, but define interval start time?

[Martin Weil]

Thank you for your reply.

But I don't know if I understood that correctly, so I try to give a better example (and then maybe you can elaborate in more detail what you meant?):

Let's say I have only the following entries in my DB:

datetime | value1
00:00:00 | 1
00:30:00 | 2
01:00:00 | 3
01:30:00 | 4
02:00:00 | 5
02:30:00 | 6
03:00:00 | 7
03:30:00 | 8
04:00:00 | 9
04:30:00 | 10
05:00:00 | 11

With my former approach it would calculate 3 "bins":
- 00:00:00 to 01:59:59 with SUM 1+2+3+4 = 10
- 02:00:00 to 03:59:59 with SUM 5+6+7+8 = 26
- 04:00:00 to 05:59:59 with SUM 9+10+11 = 30

But I would need those "bins":
- 00:30:00 to 2:29:59 with SUM 2+3+4+5 = 14
- 02:30:00 to 4:29:59 with SUM 6+7+8+9 = 30
- 04:30:00 to 6:29:59 with SUM 10+11 = 21


I don't understand how relabelling would help me here. I THINK you meant that I should select my data (beginning from 0:30) with the INNER query and then somehow do my calculations on this data from an outer query, correct?

Would you please be so kind as to elaborate a little more?
Thank you :-)