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

0 vote230 views1 answer
Get last run query sql server
SQL
3 votes257 views1 answer
Index using in query plsql
SQL
12 votes265 views5 answers
Sql primary key
SQL
0 vote290 views1 answer
Mysql value ends with
SQL
1 vote355 views1 answer
Sql and
SQL
0 vote268 views2 answers
Sql update multiple tables
SQL
0 vote254 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote275 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote271 views1 answer
Insert array into mysql column
SQL
3 votes272 views2 answers
How to start postgresql on windows
SQL