Oracle:
Select
to_char(add_months(trunc('2018-08-06', 'month'), Rownum ), 'yyyy-mm') as dateStr
From
dual
Connect By Rownum <= 6
结果:
Sql Server:
SELECT
CONVERT(char(7), DATEADD(mm,number,'2018-02-21'),120) AS monthStr
FROM
master..spt_values
WHERE type = 'p'
AND DATEDIFF(MONTH,DATEADD(mm,number,'2018-02-21'),'2019-02-21') < 12
AND DATEDIFF(MONTH,DATEADD(mm,number,'2018-02-21'),'2019-02-21') >= 0
结果:
可以用此做主表左连接查询一些数据