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

3 votes229 views3 answers
Into in sql
SQL
1 vote267 views2 answers
Install sql server management studio ubuntu
SQL
1 vote218 views1 answer
Set statistics on in ssms
SQL
11 votes259 views1 answer
Oracle export view ddl
SQL
1 vote212 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote239 views1 answer
Shortcut run sql pgadmin
SQL
0 vote254 views1 answer
Show specific events on mysql
SQL
0 vote250 views1 answer
What is delimiter in mysql
SQL
103 votes369 views1 answer
Like sql
SQL
0 vote210 views1 answer
Dump only schema
SQL