[sql] view plain copy print ? select date(zz) from generate_series(date_trunc('month',to_date('20150305','yyyymmdd')), date_trunc('month',to_date('20150705','yyyymmdd')),'1 month') as tt(zz); 结果为: 转载于:https://www.cnblogs.com/kungfupanda/p/4365626.html