GROUP BY DATEPART(YEAR, DT.[Date]), DATEPART(MONTH, DT.[Date]), DATEPART(DAY, DT.[Date]), DATEPART(HOUR, DT.[Date]), (DATEPART(MINUTE, DT.[Date]) / 10)
https://stackoverflow.com/questions/5002661/how-to-group-time-by-hour-or-by-10-minutes
No comments:
Post a Comment