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

1 vote183 views1 answer
Mysql date diff in seconds
SQL
16 votes181 views3 answers
Delete row psql
SQL
0 vote138 views1 answer
Kannst du deine finger trainieren
SQL
16 votes189 views3 answers
Tsql rename column name
SQL
0 vote178 views1 answer
Oracle synonym procedure
SQL
0 vote185 views1 answer
Mysql trim characters
SQL
0 vote186 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote213 views1 answer
How to check foreign key constraint in sql
SQL
0 vote200 views1 answer
Postegresql update to null
SQL
21 votes194 views4 answers
Oracle add column
SQL