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

0 vote197 views1 answer
Components/Fields of Internal Table
SQL
1 vote244 views2 answers
Limit sqlserver
SQL
3 votes197 views1 answer
Locate sql server
SQL
1 vote182 views1 answer
Set statistics on in ssms
SQL
0 vote192 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote189 views1 answer
Postgresql where clause not working
SQL
1 vote199 views2 answers
How to enable error squiggles in vs code
SQL
8 votes199 views1 answer
How to check mysql version in xampp
SQL
0 vote201 views1 answer
Provide hardcoded value in the mysql query
SQL
-1 vote208 views1 answer
How to open blade file from blade in laravel
SQL