Hello, I only want my query to select this date range. In the pic attached, The first column is the ID column. The value for the ID should be the same for the whole picture. Ignore the "count of date" column. What im interested in is selecting the proper values in the "DATE" column.
The way it works is there should be 24 hour intervals for every day of the month, per ID.
However, I want the query to check STARTING from 1 AM all the way through the first hour of the next day. So in this picture, instead of selecting 24 hours of 5/1, i want it to only select 23 hours of 5/1 and one row of the first hour of the following day, so in this case it would be 5/2 (the row that is highlighted). It should ignore the first 5/1 at the top of the picture.
The reason is because in this example, "5/2/2012" is actually representing the midnight hour which is 00:00 but out machine converts it to the following day instead.
so again, query should spit out
5/1/2012 1:00:00 AM through 5/2/2012 and stop before 5/2/2012 1:00:00 AM
THANKS SO MUCH