check if times overlap

[AviNahum]

hello,

i have an event reservation system. i need to make sure that every time someone is booking a new time, it's not overlap another reservation.

 

for example lets say i have an event reserved starting at X and ending at Y

X = Wed Sep 10 2014 07:30:00 GMT+0000
Y = Wed Sep 10 2014 08:00:00 GMT+0000

and now im reserving a new event

start = Wed Sep 10 2014 09:30:00 GMT+0000
end = Wed Sep 10 2014 09:30:00 GMT+0000

how can i check if they are not crushing?

lets say the first event starts at 12:00 and end 14:00,

i need to make sure that the new event is not held between these hours.

it need to be started and end before 12:00 or after 14:00.

 

thanks in advance!

[requinix]

There's no overlap with either of 7:30-8:30 or 12:00-14:00...

 

The two will overlap if the new start time is before the existing end time and the new end time is after the existing start time.