MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.30


create table tb_absen_mingguan(
  id INT NOT NULL auto_increment not null primary key,
  tanggal datetime not null
);
INSERT INTO tb_absen_mingguan(tanggal)
VALUES ('2023-07-28 00:00:00'),('2023-07-29 00:00:00'), ('2023-07-27 00:00:00'),
('2023-07-26 00:00:00'), ('2023-07-05 00:00:00'), ('2023-07-04 00:00:00'),
('2023-07-03 00:00:00');

Records: 7  Duplicates: 0  Warnings: 0


select * from tb_absen_mingguan;


id
tanggal


1
2023-07-28 00:00:00

2
2023-07-29 00:00:00

3
2023-07-27 00:00:00

4
2023-07-26 00:00:00

5
2023-07-05 00:00:00

6
2023-07-04 00:00:00

7
2023-07-03 00:00:00


DELETE FROM tb_absen_mingguan WHERE tanggal < DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY);
select * from tb_absen_mingguan;


id
tanggal


1
2023-07-28 00:00:00

2
2023-07-29 00:00:00

3
2023-07-27 00:00:00

4
2023-07-26 00:00:00

id	tanggal
1	2023-07-28 00:00:00
2	2023-07-29 00:00:00
3	2023-07-27 00:00:00
4	2023-07-26 00:00:00
5	2023-07-05 00:00:00
6	2023-07-04 00:00:00
7	2023-07-03 00:00:00