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

>>>>> "pablopumarino" == pablopumarino  <pablopumarino@gmail.com> writes:

 pablopumarino> SELECT generate_series('2016-08-01', '2016-08-31', '1 day'::interval)::date

Does it work better if you do:

SELECT generate_series(timestamp '2016-08-01', '2016-08-31', '1 day'::interval)::date;

?

(Your version is using timestamp with time zone, which is probably not a
good idea)

Also, what is the output you get for:

SELECT d, d::date FROM generate_series('2016-08-01', '2016-08-31', '1 day'::interval) AS d;

--
Andrew (irc:RhodiumToad)