Does Informix have a function equivalent to OVERLAPS, which finds out whether or not two time intervals have any time in common?
OVERLAPS for Informix
date formatinformix
Related Question
- Can’t Select a View on Informix
- Moving the IBM Informix IFMXDATA directory to another machine
- Informix help – SQL DBA
- Informix – Getting all descendants of a parent
- SQL Server – Informix DB Linked Server Configuration
- Sql-server – Informix DB export to Microsoft SQL Server 2016
- Informix v12 substitute for query using multiple with statements
Best Answer
I don't think there is a
OVERLAPS()
function that you could use. You'll have to stick to the usual test:Change
<
to<=
, depending on how you want your Overlap test to function on end cases, when an end time (or date) is exactly the same as the other start time. I guess such behaviour may be wanted for dates.