How to Test for Overlapping Dates in PostgreSQL

PHOTO EMBED

Wed Mar 30 2022 12:28:02 GMT+0000 (Coordinated Universal Time)

Saved by @repo #sql

SELECT (date '2022-01-09', date '2022-02-10') OVERLAPS
       (date '2022-02-10', date '2022-03-10');
content_copyCOPY

https://database.guide/how-to-test-for-overlapping-dates-in-postgresql/