Oracle查询某个日期的周一到周日SQL语句
SELECT TRUNC(to_date('2021-12-27','YYYY-MM-DD'),'IW')+(ROWNUM-1)*6 FROM
dual
CONNECT BY ROWNUM<=2
Oracle查询某个日期的周一到周日SQL语句
SELECT TRUNC(to_date('2021-12-27','YYYY-MM-DD'),'IW')+(ROWNUM-1)*6 FROM
dual
CONNECT BY ROWNUM<=2