Oracle数据库如何获取当前自然周,当前周的起始和结束日期

yyyyMMdd格式

--本周

SELECT to_char(TRUNC(TO_DATE(to_char(sysdate,'yyyy-MM-dd'),'yyyy-MM-dd'),'IW'),'yyyyMMdd')  FROM DUAL;

SELECT to_char(TRUNC(TO_DATE(to_char(sysdate,'yyyy-MM-dd'),'YYYY-MM-DD'),'IW') + 6,'yyyyMMdd') FROM DUAL;

--本季

select to_char(trunc(sysdate, 'Q'),'yyyyMMdd') from dual;

select to_char(add_months(trunc(sysdate, 'Q'), 3) - 1,'yyyyMMdd') from dual;

yyyy-MM-dd格式

--本周

select trunc(sysdate, 'd') + 1 from dual;

select trunc(sysdate, 'd') + 7 from dual;

--本月

select trunc(sysdate, 'mm') from dual;

select last_day(trunc(sysdate)) from dual;

--本季

select trunc(sysdate, 'Q') from dual;

select add_months(trunc(sysdate, 'Q'), 3) - 1 from dual;