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

10 votes369 views2 answers
Sql pagination offset
SQL
0 vote364 views1 answer
Add a new column into table
SQL
0 vote377 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote375 views1 answer
Shortcut run sql pgadmin
SQL
21 votes306 views7 answers
Table drop if exist sql server
SQL
0 vote371 views1 answer
On delete set default
SQL
5 votes374 views1 answer
How to get all table names in sql query
SQL
8 votes392 views3 answers
Postgres database sizes
SQL
0 vote350 views1 answer
Mariadb hours between two dates
SQL
0 vote343 views1 answer
Online sql testing tool
SQL