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

3 votes171 views1 answer
Unsigned int in mysql
SQL
0 vote171 views1 answer
Mysql insert into select transaction c#
SQL
3 votes179 views1 answer
Sql select second max
SQL
1 vote101 views1 answer
Postgres reset auto increment
SQL
0 vote112 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote146 views1 answer
Mysql workbench view
SQL
0 vote167 views1 answer
View to table
SQL
0 vote182 views1 answer
Sql query to find percentage of null values in a table
SQL
1 vote170 views2 answers
End mysql command
SQL
2 votes100 views1 answer
Select sid oracle
SQL