Mysql sysdate

 -- 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 vote267 views1 answer
Change database name psql 8
SQL
0 vote257 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote259 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote262 views1 answer
Null column as zero in mysql
SQL
0 vote289 views1 answer
Cartesian product sql
SQL
0 vote246 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote244 views2 answers
MySQL top percent
SQL
0 vote254 views1 answer
Mysql query problems and solutions
SQL
22 votes330 views1 answer
Mysql workbench
SQL
0 vote246 views1 answer
Sqlite3 update select
SQL