Mysql date minus 1 day

 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

10 votes81 views1 answer
Oracle view dependencies
SQL
0 vote141 views1 answer
Postgresql linux password
SQL
14 votes157 views6 answers
Finding duplicate rows mysql
SQL
0 vote121 views1 answer
Where in clause tsql
SQL
-1 vote135 views2 answers
Postgresql get last 10 records
SQL
0 vote135 views1 answer
Oracle synonym procedure dblink
SQL
0 vote155 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote132 views2 answers
Postgresql get last day of month
SQL
0 vote125 views1 answer
How to reset AI in sql
SQL
0 vote127 views1 answer
Select top 3 sql
SQL