Hello guys. I have a problem to check datetime overlapping in oracle database.
I have this kind of data in my table in oracle.

2011-01-01 08:00:00
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


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?

Recommended Answers

All 3 Replies

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.