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

1 vote242 views1 answer
Floor function in sql oracle
SQL
0 vote254 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote201 views1 answer
Check index sql server
SQL
0 vote212 views1 answer
Get cpu details sql
SQL
1 vote210 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote211 views1 answer
Get foreign table names mysql
SQL
0 vote236 views1 answer
Postgresql find biggest table
SQL
6 votes207 views3 answers
Mysql server is not starting xampp
SQL
0 vote203 views1 answer
Mysql xampp reset root password
SQL
1 vote230 views1 answer
Influxdb export to csv
SQL