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 vote286 views1 answer
Difference between db.query and db.execute
SQL
0 vote292 views1 answer
Sql select where more than one record exists
SQL
0 vote651 views1 answer
Sql field equals multiple values
SQL
0 vote300 views1 answer
Sql server information_schema temp tables
SQL
0 vote312 views1 answer
Sql server for loop
SQL
0 vote266 views1 answer
Select value from previous row in postgresql
SQL
0 vote288 views1 answer
Get number of rows in every table mysql
SQL
3 votes324 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
2 votes316 views1 answer
Query to check cpu utilization in oracle database
SQL
1 vote282 views1 answer
Sql server 2016 reseed identity
SQL