1.直接获取
select to_char(sysdate,‘q’) from dual;
2.trunc函数获取
Select trunc((to_char(sysdate,‘mm’)+2)/3) from dual;
3.ceil函数获取
select ceil(to_number(to_char(sysdate,‘mm’))/3) from dual;
oracle获取当前季度
最新推荐文章于 2024-07-19 14:51:10 发布
1.直接获取
select to_char(sysdate,‘q’) from dual;
2.trunc函数获取
Select trunc((to_char(sysdate,‘mm’)+2)/3) from dual;
3.ceil函数获取
select ceil(to_number(to_char(sysdate,‘mm’))/3) from dual;