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?

Is it an attendance system ?

something like dat.
It will be used to calculate overtime allowance later..

Member Avatar

If EndDate > Start_Date and StartDate < End_Date then OVERLAP!
-- I worked on a bus/operator scheduling system for the Municipal Transit Authority.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.