Re: BUG #14294: Problem in generate series between dates - Mailing list pgsql-bugs

pablopumarino@gmail.com writes:
> When I use postgres function:
> SELECT generate_series('2016-08-01', '2016-08-31', '1
> day'::interval)::date
> it gives me the corresponding list of days but for some reason it misses the
> day 2016-08-31.

In addition to Andrew's questions:

* What time zone are you using?
* In that zone, is there a DST rule change near 2016-08-31?

            regards, tom lane