返回月度区间
select to_char(trunc(sysdate,‘mm’),‘yyyy/mn/dd’)
||’~’||to_char(last_day(trunc(sysdate)),‘yyyy/mm/dd’) from dual
返回季度区间
select case when mod(to_number(to_char(trunc(sysdate,‘mm’),‘yyyy/mm/dd’)))=0
then
to_char(add_months(trunc(sysdate,‘mm’),-2),‘yyyy/mm/dd’)||’~’||to_char(last_day(trunc(sysdate)),‘yyyy/mm/dd’)
when
mod(to_number(to_char(trunc(sysdate,‘mm’),‘yyyy/mm/dd’)))=1 then
to_char((trunc(sysdate,‘mm’),‘yyyy/mm/dd’)||’~’||to_char(add_months(last_day(trunc(sysdate)),2),‘yyyy/mm/dd’)
when
mod(to_number(to_char(trunc(sysdate,‘mm’),‘yyyy/mm/dd’)))=2 then to_char(add_months(trunc(sysdate,‘mm’),-1),‘yyyy/mm/dd’)||’~’||to_char(add_months(last_day(trunc(sysdate)),1),‘yyyy/mm/dd’)
from dual
输入日期返回月份区间季度区间
最新推荐文章于 2022-03-28 17:00:20 发布