You will need to modify your GROUP BY to match, and you may want to use the whole ROUND(…) expression to avoid any unexpected float rounding. If you want to round your intervals inward such that each timestamp represents half an interval before and half an interval after it, use something like this: DATEADD(MINUTE, ROUND(1.
0 Comments
Leave a Reply. |