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

1 vote141 views1 answer
Count of tables in database mysql
SQL
23 votes123 views4 answers
Sql server substring
SQL
0 vote119 views1 answer
Oracle drop type
SQL
0 vote114 views1 answer
Monthly Birthday SQL Query
SQL
0 vote168 views1 answer
Site:av.ru "files"
SQL
2 votes118 views1 answer
Oracle generated column
SQL
0 vote117 views2 answers
Script all indexes in a database
SQL
0 vote121 views1 answer
UNION ALL LEFT JOIN
SQL
8 votes121 views3 answers
Postgres connection string
SQL
0 vote123 views1 answer
Drop CHECK constraint sql
SQL