Sysdate in sql

 -- 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 vote131 views1 answer
Mysql search like but first exact match
SQL
1 vote133 views1 answer
Oracle list datafiles in tablespace
SQL
-1 vote129 views1 answer
Pl/sql how to delete a trigger
SQL
-1 vote135 views1 answer
Export mysql table to file
SQL
5 votes127 views2 answers
Add column postgres with default value
SQL
0 vote133 views1 answer
Mariadb errno 121
SQL
0 vote127 views1 answer
Mysql create table columns with spaces
SQL
29 votes127 views6 answers
Delete all rows from table mysql
SQL
-1 vote167 views1 answer
Mysql faster insert
SQL
2 votes126 views1 answer
Install sqlite npm
SQL