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 vote193 views2 answers
How to tun mysql on ubunto
SQL
10 votes206 views2 answers
Sql pagination offset
SQL
0 vote185 views1 answer
Dapper run sql script with parameters
SQL
0 vote194 views1 answer
Sql insert query list of dictionaries
SQL
0 vote187 views1 answer
Add plugins to mysql workbench
SQL
0 vote200 views1 answer
Mssql dockere
SQL
2 votes206 views1 answer
Mysql change data type of column
SQL
0 vote199 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote197 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
0 vote182 views1 answer
Database springboot
SQL