Getting results between two dates in PostgreSQL

by 
 SELECT *
   FROM mytable
  WHERE (start_date, end_date) OVERLAPS ('2012-01-01'::DATE, '2012-04-12'::DATE);

Datetime functions is the relevant section in the docs.

More Related Contents:

  1. Find overlapping date ranges in PostgreSQL
  2. How do you do date math that ignores the year?
  3. Getting date list in a range in PostgreSQL
  4. PostgreSQL: how to convert from Unix epoch to date?
  5. Check whether string is a date Postgresql
  6. How to compare dates in datetime fields in Postgresql?
  7. Postgresql query between date ranges
  8. Query for count of distinct values in a rolling date range
  9. How to return only the Date from a SQL Server DateTime datatype
  10. Computed / calculated / virtual / derived columns in PostgreSQL
  11. Insert data in 3 tables at a time using Postgres
  12. What is the difference between single quotes and double quotes in PostgreSQL?
  13. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  14. PostgreSQL: Which Datatype should be used for Currency?
  15. Best way to count rows by arbitrary time intervals
  16. PostgreSQL sequence based on another column
  17. Finding similar strings with PostgreSQL quickly
  18. Select data from date range between two dates
  19. Sort NULL values to the end of a table
  20. How to compare the current row with next and previous row in PostgreSQL?
  21. Window Functions or Common Table Expressions: count previous rows within range
  22. Continuing a transaction after primary key violation error
  23. Select (retrieve) all records from multiple schemas using Postgres
  24. Optimize groupwise maximum query
  25. Use email address as primary key?
  26. PostgreSQL – fetch the rows which have the Max value for a column in each GROUP BY group
  27. SQL query to find record with ID not in another table
  28. Get execution time of PostgreSQL query
  29. Postgresql tables exists, but getting “relation does not exist” when querying
  30. Why isn’t row level security enabled for Postgres views?

Leave a Comment