Timeline for Group by minute and two minute intervals
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 16, 2012 at 19:27 | comment | added | Aaron Bertrand | Sure, if the where clause limits all of the data to within a single hour, it meets the criteria. I don't think that's explicit enough in either the question or your answer. IMHO. | |
| May 16, 2012 at 19:12 | comment | added | Jon of All Trades | If that's part of the OP's goal, then certainly yes. This query meets the criteria "group queries for X minute intervals." Expand upon it as necessary. | |
| May 16, 2012 at 17:23 | comment | added | JNK |
Won't this group together across hours? 4:30 will be combined with 5:30 and 6:30 since the minute is the same across the board. You need to include date and hour as well at a minimum.
|
|
| May 16, 2012 at 17:21 | history | edited | Jon of All Trades | CC BY-SA 3.0 |
Typo
|
| May 16, 2012 at 16:50 | comment | added | Jon of All Trades | Yes, but since it does not preserve fractions the net result is to round down to the nearest multiple of five. | |
| May 16, 2012 at 16:48 | comment | added | dublintech | Why are you multiplying and dividing by 5. Do they cancel each other out? | |
| May 16, 2012 at 16:33 | history | answered | Jon of All Trades | CC BY-SA 3.0 |