Oracle获取每周一的开始日期

--展示一个月的周一开始日期

SELECT TRUNC(To_date(To_char(Trunc(add_months(sysdate, -1) + 6),
'yyyy/mm/dd'),
'yyyy/mm/dd') + (ROWNUM) * 7,
'D') + 1 AS START_DATE,
TRUNC(To_date(To_char(Trunc(add_months(sysdate, -1) + 6),
'yyyy/mm/dd'),
'yyyy/mm/dd') + (ROWNUM) * 7,
'D') + 7 AS END_DATE
FROM DUAL
CONNECT BY ROWNUM <= TRUNC(trunc(sysdate) -
To_date(To_char(Trunc(add_months(sysdate, -1)),
'yyyy/mm/dd'),
'yyyy/mm/dd')) / 7;