Here's an edge case to keep in mind when querying the database for something that has duration (for example, events) using afrom..to date/time filter: long events can startbeforefrom and endafterto.
So if we check only that thestart orend time of the event fall within the interval, we can miss an event, even though it overlaps ("covers") the required interval.