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 vote217 views1 answer
Sql min
SQL
0 vote181 views1 answer
Pl sql join 3 tables
SQL
2 votes192 views2 answers
Change mysql password from command line
SQL
8 votes193 views1 answer
Show mysql user table
SQL
0 vote177 views1 answer
Sql server list user permissions
SQL
0 vote188 views1 answer
Sql on-premises
SQL
0 vote216 views1 answer
Time in sql server
SQL
2 votes220 views1 answer
Oracle current date without time
SQL
0 vote203 views1 answer
How to define a non primary composite key in sql
SQL
0 vote227 views1 answer
Mysqlimport
SQL