本帖最后由 jrtongxin5266 于 2016-12-5 16:30 编辑
我只会这种笨方法:
Select to_char(add_months(sysdate,-3),'yyyy'),to_char(add_months(sysdate,-3),'q') from dual
union all
select to_char(sysdate,'yyyy'),to_char(sysdate,'q') from dual
union all
Select to_char(add_months(sysdate,3),'yyyy'),to_char(add_months(sysdate,3),'q') from dual
|