sql语句得到近五年的年份

[kangchongmian]

求一个sql语句，可以从oracle的dual表中得到近五年的年份值，即查询结果为
2008
2009
2010
2011
2012

[zlb_chen]

select to_char(sysdate,'yyyy') from dual
union
select to_char(sysdate-365,'yyyy') from dual
union
select to_char(sysdate-365*2,'yyyy') from dual
union
select to_char(sysdate-365*3,'yyyy') from dual
union
select to_char(sysdate-365*4,'yyyy') from dual

[大明湖畔_帅锅]

[Quote=引用 3 楼 的回复:]

select to_char(sysdate,'yyyy') from dual
union
select to_char(sysdate-365,'yyyy') from dual
union
select to_char(sysdate-365*2,'yyyy') from dual
union
select to_char(sysdate-365*3,'yyyy') from ……
[/Quote]

5年中就没闰年 ？

[coolkisses]

SELECT to_char(SYSDATE,'YYYY') - LEVEL + 1 years
    FROM dual
    connect by LEVEL <= 5
    ORDER BY 1

[大明湖畔_帅锅]

LS的是转换先成年了 再计算 也可以先计算再转成年

select to_char(add_months(sysdate,-12*(level-1)),'yyyy') yy
from dual
connect by level<=5