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 vote320 views2 answers
How to start postgresql laravel
SQL
0 vote322 views1 answer
Find largest table in mysql database
SQL
3 votes341 views1 answer
Oracle sleep
SQL
0 vote335 views1 answer
Select nth row in mysql
SQL
19 votes308 views1 answer
Sqrt(-1)
SQL
0 vote345 views1 answer
Oracle list of long running queries
SQL
0 vote327 views1 answer
Get number of rows in every table mysql
SQL
0 vote322 views1 answer
Mysql add comment to column
SQL
3 votes332 views2 answers
Brew start mysql
SQL
2 votes348 views3 answers
Postgres create view
SQL