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

2 votes167 views1 answer
Oracle log files
SQL
2 votes170 views1 answer
How to search table name in stored procedure in sql server
SQL
3 votes162 views1 answer
Oracle wait
SQL
6 votes170 views1 answer
SQL insert all columns
SQL
1 vote172 views1 answer
Oracle rolling back transactions
SQL
1 vote179 views2 answers
Mssql show database size
SQL
1 vote171 views2 answers
Restart identity cascade
SQL
0 vote178 views1 answer
Sqlalchemy orm duplicate
SQL
1 vote187 views1 answer
Oracle grant select on schema
SQL
4 votes166 views2 answers
Tables in sql
SQL