mysql date minus 1 day

Solutions on MaxInterview for mysql date minus 1 day by the best coders in the world

showing results for - "mysql date minus 1 day"
Leni
26 Jan 2017
1 SELECT SYSDATE();								-- 2021-07-13 06:12
2 SELECT DATE_ADD(SYSDATE(), INTERVAL 1 DAY);	-- 2021-07-14 06:12
3 SELECT DATE_ADD(SYSDATE(), INTERVAL -1 DAY);	-- 2021-07-12 06:12
4 SELECT DATE(SYSDATE());						-- 2021-07-13 00:00
5 
6 -- ⇓ Test it ⇓ (Fiddle source link)