Member Avatar for lili.edryana

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?

  • 3 Contributors
  • 3 Replies
  • 132 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by hfx642

Recommended Answers

All 3 Replies

Member Avatar for debasisdas

Is it an attendance system ?

Member Avatar for lili.edryana

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

Edited by lili.edryana because: n/a
Member Avatar for hfx642

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

Edited by hfx642 because: n/a
Be a part of the DaniWeb community

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