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 vote179 views1 answer
The local psql command could not be located
SQL
0 vote189 views2 answers
Sqlalchemy core in clause
SQL
0 vote158 views1 answer
Como leer datos de mysql esp32
SQL
0 vote172 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote183 views1 answer
How to use select union and loop
SQL
1 vote171 views2 answers
Sql groub by count
SQL
2 votes178 views2 answers
Mysql limit
SQL
1 vote184 views1 answer
Join first name and last name sql
SQL
5 votes193 views1 answer
Mysql where one year ago
SQL
0 vote175 views1 answer
Top 3 salary in sql
SQL