This article provides a brief overview of PostgreSQL date data types and discusses how to use the WHERE and BETWEEN clauses, DATE_TRUNC and data type formatting functions, and the RANGE type to compare dates in PostgreSQL - https://www.devart.com/dbforge/postgresql/studio/compare-dates.html