如果当前季度为第一季度,就取1,如果为其他季度,则季度-1
select to_char(sysdate,'q')from dual,数据库为oracle数据库
select (case when to_char(sysdate,'q')=1 then 1 else -1 end),to_char(sysdate,'q') from dual
select decode(to_char(sysdate,'q'),1,1,to_char(sysdate,'q')-1) quarter from dual
select (case when to_char(sysdate,'q')=1 then 1 else -1 end) as a ,to_char(sysdate,'q') as b from dual