Ok. Maybe I have not come out clear here. I have a list of data between diff. time periods (so, there's data between 00:00-08:00,08:00-15:00,20:00-08:00 .. so on and so forth). I have an input field (say, 2012-01-25 21:00). Now I wish to retrieve all data with a time window that includes 21:00.
The time periods are in two cols. [FROM_WINDOW;TO_WINDOW].