Hello guys. I have a problem to check datetime overlapping in oracle database.
I have this kind of data in my table in oracle.
START_DATE
2011-01-01 08:00:00
END_DATE
2011-01-01 16:30:00
Given datetime from user is something like this :
----------------------------------------------------------
StartDate = 2011-01-01 07:30:00
EndDate = 2011-01-01 16:20:00
OR
StartDate = 2011-01-01 08:30:00
EndDate = 2011-01-01 18:00:00
-----------------------------------------------------------
How do I check the datetime is still overlap with the data in oracle?