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 vote159 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote108 views1 answer
Update sql join multiple tables
SQL
103 votes2K views1 answer
Like sql
SQL
0 vote146 views1 answer
First mysql
SQL
2 votes164 views1 answer
Express api ith mysql data
SQL
0 vote182 views2 answers
What is rownum in oracle
SQL
25 votes178 views1 answer
How to update an attribute in MySQL
SQL
8 votes168 views1 answer
Ltrim sql
SQL
0 vote155 views1 answer
Alter precision
SQL
2 votes176 views1 answer
Create delete procedure mysql
SQL