I have this query where you have to get all the data from a certain date and ranges of time. For example.
Date: 01.01.06 - 01.02.06
Time ranges: 07:00:00 - 23:59:59
00:00:00 - 07:00:00
The problem is that I'm getting the data of 00:00:00-07:00:00 for the first date and data from 07:00:00-23:59:59 of the second date.
I just want to query the data from 7am to 7am of the following date.
Thanks for any help you may give.