select date(zz) from generate_series(date_trunc('month',to_date('20150305','yyyymmdd')),date_trunc('month',to_date('20150705','1 month') as tt(zz);
结果为:
select date(zz) from generate_series(date_trunc('month',to_date('20150305','yyyymmdd')),date_trunc('month',to_date('20150705','1 month') as tt(zz);
结果为: