with
mon as(
select
mon::date mon
from generate_series(date_trunc('year', now())::date, date_trunc('year', now())::date + '+1y -1d'::interval,'1mon'::interval) mon
)
select
*
from mon
查询结果
with
mon as(
select
mon::date mon
from generate_series(date_trunc('year', now())::date, date_trunc('year', now())::date + '+1y -1d'::interval,'1mon'::interval) mon
)
select
*
from mon
查询结果