I need to selet events from a table that happen during a certain time period. The only problem is how do you do this when the time period involved is over two days?
In my table I have start time and end time.
EX.
Start Time/End Time
0630/0800
0800/0100
2300/0430
0400/0530
1200/1300
2200/2300
I want to select al the events that take place between 2200 and 0600. The following results should come back:
0800/0100
2300/0430
0400/0530
2200/2300
And help you can provide would be greatly appreciated.