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