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 vote109 views1 answer
Date datatype in livesql
SQL
0 vote133 views1 answer
Select count concat string sql server
SQL
3 votes128 views1 answer
Oracle sql commit example
SQL
3 votes131 views1 answer
Define REGEXP?
SQL
2 votes126 views1 answer
Sql server current date minus 5 years
SQL
1 vote113 views1 answer
Multiple count in sql
SQL
10 votes142 views1 answer
Oracle all_dependencies
SQL
0 vote109 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote105 views1 answer
RowDataPacket
SQL
2 votes109 views2 answers
Postgres trigger insert into another table
SQL