Mysql sysdate - 1 day

 -- Sysdate in MySQL
 SELECT SYSDATE();								-- 2021-07-13 06:12
 SELECT DATE_ADD(SYSDATE(), INTERVAL 1 DAY);	-- 2021-07-14 06:12
 SELECT DATE_ADD(SYSDATE(), INTERVAL -1 DAY);	-- 2021-07-12 06:12
 SELECT DATE(SYSDATE());						-- 2021-07-13 00:00
 
 -- ⇓ Test it ⇓ (Fiddle source link)

Source: sqlfiddle.com

Similar codes

2 votes135 views1 answer
Search query in mysql
SQL
0 vote105 views1 answer
Sql server size of every table in a db
SQL
8 votes101 views2 answers
Between operator
SQL
0 vote110 views1 answer
Mysql pad zeros
SQL
1 vote101 views1 answer
How to drop function in sql
SQL
0 vote110 views1 answer
Mysql workbench procedure
SQL
0 vote145 views1 answer
Stop and start mysql
SQL
3 votes112 views2 answers
Postgres alter table owner
SQL
1 vote117 views1 answer
Postgres left join
SQL
0 vote96 views1 answer
Get sum sqlite android
SQL