Generate day rows from date range

Question

I would like to run a query like

select ... as days where `date` is between '2010-01-28' and '2010-02-03'

And return data like:

days
---
28
29
30
31
1
2
3

Sorry, Actually PostgreSQL for a report – morne Sep 23 '14 at 10:55 — morne, Sep 23 '14 at 10:55

score 2 · Accepted Answer · answered Sep 23 '14 at 11:12

2

select extract(day from d) as days
from generate_series(timestamp '2010-01-28', timestamp '2010-02-03', interval '1' day) as d
order by d;

answered Sep 23 '14 at 11:12

1 Answers1