TRUNC (sysdate, 'IW') return monday select TRUNC (sysdate, 'IW')-2 ,trunc(sysdate,'iw'),sysdate from dual https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/TRUNC-date.html#GUID-BC82227A-2698-4EC8-8C1A-ABECC64B0E79