By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select curdate();
| curdate() |
|---|
| 2021-10-02 |
select curdate()+0;
| curdate()+0 |
|---|
| 20211002 |
select curdate()-2;
| curdate()-2 |
|---|
| 20211000 |
select date_add(curdate(), interval -2 day);
| date_add(curdate(), interval -2 day) |
|---|
| 2021-09-30 |