SQL 当前季度的查询 select trunc((to_char(sysdate,‘mm’)+2)/3) from dual; select to_char(sysdate,‘q’) from dual; 都对,进行验证过。 quarter 季度–简写为q
select to_char(sysdate,‘q’) from dual;