intermediate date MySQL MariaDB SQL Server PostgreSQL SQLite
Detect Overlapping Date Ranges
Find rows whose date or timestamp intervals intersect by checking that neither range ends before the other begins — using the `OVERLAPS` operator in PostgreSQL or a manual comparison in other engines.