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 vote122 views1 answer
Join first name and last name sql
SQL
0 vote149 views1 answer
Recently updated stored procedure in sql server
SQL
8 votes134 views3 answers
Postgres connection string
SQL
11 votes136 views2 answers
MySQL DISTINCT
SQL
0 vote129 views1 answer
Sql server bool select
SQL
0 vote134 views1 answer
Recover deleted data from mysql database
SQL
3 votes155 views2 answers
Enter mysql command line
SQL
0 vote152 views1 answer
Hierarchal database table
SQL
4 votes134 views3 answers
Postgres set default value
SQL
-2 votes125 views1 answer
How to open database
SQL