Select data from date range between two dates

by

interval intersection description

As you can see, there are two ways to get things done:

  • enlist all acceptable options
  • exclude all wrong options

Obviously, second way is much more simple (only two cases against four).

Your SQL will look like: 

SELECT * FROM Product_sales 
WHERE NOT (From_date > @RangeTill OR To_date < @RangeFrom)

More Related Contents:

  1. Current date in Oracle Db
  2. How to return only the Date from a SQL Server DateTime datatype
  3. How to populate a table with a range of dates?
  4. Comparing date ranges
  5. Generate Dates between date ranges
  6. Oracle’s default DATE format
  7. Get the week start date and week end date from week number
  8. How to determine the number of days in a month in SQL Server?
  9. Group by month and year in MySQL
  10. How to convert an integer (time) to HH:MM:SS::00 in SQL Server 2008?
  11. Difference between datetime and timestamp in sqlserver? [duplicate]
  12. How do you do date math that ignores the year?
  13. Find closest date in SQL Server
  14. Query comparing dates in SQL
  15. Getting date list in a range in PostgreSQL
  16. How to compare two dates to find time difference in SQL Server 2005, date manipulation
  17. How to calculate the number of “Tuesdays” between two dates in TSQL?
  18. PostgreSQL: how to convert from Unix epoch to date?
  19. Get month name from date in Oracle
  20. SQL “between” not inclusive
  21. Check if current date is between two dates Oracle SQL
  22. Comparing with date in Oracle sql
  23. sqlite select with condition on date
  24. how to remove time from datetime
  25. How to compare dates in datetime fields in Postgresql?
  26. Postgresql query between date ranges
  27. Getting results between two dates in PostgreSQL
  28. Subtracting Dates in Oracle – Number or Interval Datatype?
  29. Query for count of distinct values in a rolling date range
  30. Date serial in SQL?

Leave a Comment