I'd like to get the list of days between the two dates (including them) in a PostgreSQL database. For example, if I had:
- start date: 29 june 2012
- end date: 3 july 2012
then the result should be:
29 june 2012
30 june 2012
1 july 2012
2 july 2012
3 july 2012
What would be the best way of doing this in PostgreSQL?
Thanks.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…