Oracle SQL构造年月日 connect by 、dual

构造从2000年到2017年的年月日

--构造年select to_char(add_months(to_date('1999', 'yyyy'), level * 12), 'yyyy') year  from dualconnect by level <= 18;--构造年月select to_char(add_months(to_date('199912', 'yyyymm'), level), 'yyyymm') month  from dualconnect by level <= 18 * 12;--构造年月日select to_char(to_date('19991231', 'yyyymmdd') + level, 'yyyymmdd') day  from dualconnect by level <= to_date('20171231', 'yyyymmdd') -  to_date('19991231', 'yyyymmdd');