Hi All,
I have query output as below , i have all the transaction in hourly level need to split the records into 12 equal 5 minutes intervals
volume/12 Start date and end date into 12 equal interval ( when splitting into 5 mins in excepted output 00:00:00 00:05:00 ( is intentional) even though its not exactly 5 mins
any help to approach this problem is appreciated
current Query output
| S.No | Start_date
| End_date
| Volume
|
|---|
| 1 | 2018-04-01 00:00:00 | 2018-04-01 01:00:00 | 120 |
| 2 | 2018-04-01 00:00:00 | 2018-04-01 01:00:00 | 240 |
| 3 | 2018-04-01 02:00:00 | 2018-04-01 03:00:00 | 240 |
| 4 | 2018-04-01 04:00:00 | 2018-04-01 05:00:00 | 360 |
Excepted output for ROW1 from the above table
| S.No | Start_date
| End_date
| Volume
|
|---|
| 1 | 2018-04-01 00:00:00 | 2018-04-01 00:05:00 | 10 |
| 2 | 2018-04-01 00:05:00 | 2018-04-01 00:10:00 | 10 |
| 3 | 2018-04-01 00:10:00 | 2018-04-01 00:15:00 | 10 |
| 4 | 2018-04-01 00:15:00 | 2018-04-01 00:20:00 | 10 |
| 5 | 2018-04-01 00:20:00 | 2018-04-01 00:25:00 | 10 |
| 6 | 2018-04-01 00:25:00 | 2018-04-01 00:30:00 | 10 |
| 7 | 2018-04-01 00:30:00 | 2018-04-01 00:35:00 | 10 |
| 8 | 2018-04-01 00:35:00 | 2018-04-01 00:40:00 | 10 |
| 9 | 2018-04-01 00:40:00 | 2018-04-01 00:45:00 | 10 |
| 10 | 2018-04-01 00:45:00 | 2018-04-01 00:50:00 | 10 |
| 11 | 2018-04-01 00:50:00 | 2018-04-01 00:55:00 | 10 |
| 12 | 2018-04-01 00:55:00 | 2018-04-01 01:00:00 | 10 |