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 vote179 views1 answer
Sql select most frequent value in group
SQL
0 vote192 views4 answers
Change schema in sql server
SQL
0 vote189 views1 answer
Print boolean in plsql
SQL
1 vote186 views2 answers
Sql server backup table
SQL
0 vote186 views1 answer
Change date format in oracle query
SQL
0 vote271 views1 answer
Install ms sql server management studio
SQL
0 vote210 views1 answer
Query to insert image
SQL
2 votes327 views1 answer
How to create sql database
SQL
5 votes177 views2 answers
Sql number columns
SQL
0 vote241 views1 answer
Isnull in sqlite
SQL