I have a continous time dataset and I want to break it up into 15 minute blocks using sql.
I don't want to have to create a new table to be able to do this if I can help it.
i.e.
Time, Count
09:15, 1
09:30, 3
09:45, 0
10:00, 2
10:15, 3
.....
Does anyone have any idea of how I can do this. I presume that is use a select similar to the following:
SELECT [Some kind of data manipulation on "MyDate"]
, COUNT(ID)
FROM MyTable
GROUP BY [Some kind of data manipulation on "MyDate"]