Re: BUG #14294: Problem in generate series between dates

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pablopumarino(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14294: Problem in generate series between dates
Date: 2016-08-24 18:51:00
Message-ID: 28256.1472064660@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pablopumarino(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2016-08-24 18:53:49 Re: BUG #14290: materialized view refresh doesn't use temp_tablespace
Previous Message Kevin Grittner 2016-08-24 18:48:08 Re: BUG #14290: materialized view refresh doesn't use temp_tablespace