本周日期
select to_char(trunc(sysdate-to_number(to_char(sysdate,‘d’)))+rownum+1,‘yyyy-mm-dd’) as days
from dual connect by rownum <= to_number(to_char(sysdate,‘d’))-1

本月

select to_char(trunc(sysdate-to_number(to_char(sysdate,'dd')))+rownum,'yyyy-mm-dd') as daysfrom dual connect by rownum <= to_number(to_char(sysdate,'dd'))

本季月份

SELECT TO_CHAR(ADD_MONTHS(ADD_MONTHS(TRUNC(SYSDATE, 'YYYY'),A * 3),-ROWNUM),'YYYY-MM') daysFROM (SELECT TO_CHAR(SYSDATE,'Q') A FROM DUAL)CONNECT BY ROWNUM <= 3ORDER BY 1

本年月份

select to_char(add_months(sysdate, -t.rn), 'yyyy-mm') daysfrom dual a, (select rownum - 1 rn from dual connect by rownum < = 12) twhere to_char(add_months(sysdate, -t.rn), 'yyyy') =to_char(sysdate, 'yyyy')order by to_char(add_months(sysdate, -t.rn), 'yyyy-mm')

總結(jié)

以上是生活随笔為你收集整理的oracle查询本周本月本季本年时间的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。