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

4 votes213 views1 answer
Mysql biginteger size
SQL
0 vote242 views1 answer
Sql to excel pgadmin
SQL
0 vote233 views1 answer
Php mysqli install
SQL
3 votes208 views1 answer
Show index table
SQL
0 vote216 views1 answer
Sql server separar numeros por comas miles
SQL
9 votes202 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote234 views1 answer
Query builder doctrien return sql
SQL
58 votes368 views4 answers
Mysql drop column
SQL
5 votes207 views1 answer
Sql asynchronous stored procedure call
SQL
11 votes225 views1 answer
Mysql text type max length
SQL