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 vote208 views1 answer
Sql server system messeges
SQL
3 votes141 views1 answer
Oracle revoke grant
SQL
1 vote148 views1 answer
Oracle case
SQL
5 votes152 views2 answers
Mysql import gzip db
SQL
0 vote151 views1 answer
How to save data in database in mysql node
SQL
0 vote151 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote211 views1 answer
Select milliseconds mysql
SQL
0 vote145 views1 answer
Azure sql server check foreign key
SQL
3 votes137 views2 answers
To_char oracle
SQL
0 vote155 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL