Mysql sysdate

 -- 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

6 votes185 views2 answers
WHERE value IS sql
SQL
10 votes162 views1 answer
Oracle dependencies table
SQL
0 vote176 views1 answer
Primary key start from number
SQL
-2 votes206 views3 answers
How to fetch first 10 rows in sql
SQL
8 votes184 views3 answers
Find table for column name in sql
SQL
1 vote160 views1 answer
Sql server today minus n
SQL
2 votes200 views2 answers
Mysql date range
SQL
0 vote152 views1 answer
Delete record by id sql
SQL
0 vote158 views1 answer
How to get first 10 records of a table in mysql
SQL
1 vote165 views3 answers
How to pass password to mysql command line
SQL