Getting date list in a range in PostgreSQL

select CURRENT_DATE + i 
from generate_series(date '2012-06-29'- CURRENT_DATE, 
     date '2012-07-03' - CURRENT_DATE ) i

or even shorter:

select i::date from generate_series('2012-06-29', 
  '2012-07-03', '1 day'::interval) i

Related Contents:

  1. How do you do date math that ignores the year?
  2. Are PostgreSQL column names case-sensitive?
  3. How to return only the Date from a SQL Server DateTime datatype
  4. PostgreSQL unnest() with element number
  5. How to check if a table exists in a given schema
  6. How to use RETURNING with ON CONFLICT in PostgreSQL?
  7. Does PostgreSQL support “accent insensitive” collations?
  8. Comparing Dates in Oracle SQL
  9. How to list table foreign keys
  10. PostgreSQL: using a calculated column in the same query
  11. Optimise PostgreSQL for fast testing
  12. Fast way to discover the row count of a table in PostgreSQL
  13. How to use ANY instead of IN in a WHERE clause?
  14. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  15. Return multiple columns of the same row as JSON array of objects
  16. Normalize array subscripts so they start with 1
  17. sql ORDER BY multiple values in specific order?
  18. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  19. Delete duplicate rows (don’t delete all duplicate)
  20. Safely rename tables using serial primary key columns
  21. How do I determine the last day of the previous month using PostgreSQL?
  22. Is there something like a zip() function in PostgreSQL that combines two arrays?
  23. Change PostgreSQL columns used in views
  24. subquery in FROM must have an alias
  25. PostgreSQL multi INSERT…RETURNING with multiple columns
  26. updating table rows in postgres using subquery
  27. Why can’t I use column aliases in the next SELECT expression?
  28. Preventing adjacent/overlapping entries with EXCLUDE in PostgreSQL
  29. Finding similar strings with PostgreSQL quickly
  30. Use email address as primary key?
  31. PostgreSQL: encoding problems on Windows when using psql command line utility
  32. Polymorphism in SQL database tables?
  33. Difference between datetime and timestamp in sqlserver? [duplicate]
  34. SQL column reference “id” is ambiguous
  35. How to use multiple CTEs in a single SQL query?
  36. Postgres analogue to CROSS APPLY in SQL Server
  37. How do I ALTER a PostgreSQL table and make a column unique?
  38. Oracle equivalent of Postgres’ DISTINCT ON?
  39. Casting NULL type when updating multiple rows
  40. Bulk/batch update/upsert in PostgreSQL
  41. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  42. Export specific rows from a PostgreSQL table as INSERT SQL script
  43. SQL SERVER: Get total days between two dates
  44. How to use an ALIAS in a PostgreSQL ORDER BY clause?
  45. postgresql generate sequence with no gap
  46. I keep getting the error “relation [TABLE] does not exist”
  47. Error: Column does not exist
  48. Get execution time of PostgreSQL query
  49. Why is PostgreSQL not using my indexes on a small table?
  50. Aggregating (x,y) coordinate point clouds in PostgreSQL

Leave a Comment