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;
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;