This project is read-only.

Time of Day query..

Oct 14, 2013 at 6:54 AM

What is the best method to search for records that occur between in a certain time period during each day. For example, return all records with datetime property from 1st Oct 2013 to 10th Oct 2013, but occurring between 10AM and 12Noon on any day. We are looking for an optimal solution rather than looping through and building a BETWEEN clause for each date in the range.

Thanks in advance...