Send to a Friend

LostInParadise's avatar

Brain Teaser - How can you determine if date intervals intersect?

Asked by LostInParadise (31912points) June 30th, 2009

Given starting and ending dates for 50 different events, you want to find out if there is any time when all events are happening simultaneously. It can be done using under 100 comparisons. Do you see how?

For those of you who know how to do database queries, assuming a separate record for each event, can you solve the problem with a single select statement?

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.