输入日期返回季度第几月份

select
mod(参数,3) month
from dual
1当参数是数字型年月
select mod(to_number(substr(to_char(202007),-2)),2)
from dual
2 当参数是字符型年月
select mod(to_number(substr(‘202007’,-2)),3)
from dual
3 当参数是日期型年月
select
mod(to_nunber(to_char(sysdate,‘mm’)),3)
from dual