postgresql generating a list of dates between two dates fields

Question

I would like to get the list of dates from two fields: start and end. I found a case here: Show a list of dates between two dates?

But I would like to have a better solution without going through an intermediary table.

Here is the initial table:

Here is the result I would like to have:

Thank you

user330315 · Accepted Answer · 2021-01-14 18:55:09Z

3

Use generate_series()

select t.id, t.name, t.g.dt::date as start_end
from the_table t
  cross join generate_series(t.date_start, t.date_end, interval '1 day') as g(dt)
order by t.id, g.dt;

answered Jan 14, 2021 at 18:55

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

Bak Over a year ago

Thanks a lot for the help. it works well. That's exactly what I wanted. Thank.

Collectives™ on Stack Overflow

postgresql generating a list of dates between two dates fields

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related