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

0 vote157 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote167 views1 answer
Mysql change innodb to myisam
SQL
0 vote180 views1 answer
How to open mysql in docker
SQL
0 vote150 views1 answer
How to declare variable date in mysql
SQL
0 vote196 views1 answer
Python mysql executemany
SQL
3 votes193 views2 answers
How to open postgresql in windows
SQL
0 vote152 views1 answer
Sql server check whether column has same equal values
SQL
0 vote122 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote154 views1 answer
How to select only id where is not in column mysql
SQL
0 vote167 views2 answers
Athena drop partition
SQL