Page 1 of 1

Date query help..

Posted: Mon Feb 23, 2009 3:07 pm
by Frozenlight777
I have a dataset where there are fields; start, end, timeperiod...

I'm trying to figure out how to query the concurrent times, for example if the data was:
7:00-12:00
9:00-12:00
10:00-12:00

They are all concurrent but how would I be able to query the three times? I'm assuming there is a range function in mysql to check the range for each time to see if they match at all but I really have no idea, i'm sure it's just a math/logic problem I'm having.

Thanks