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

2 votes194 views1 answer
How to insert string variable into sqlite database
SQL
0 vote204 views1 answer
Python connect to mysql in settings.py
SQL
0 vote256 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote184 views1 answer
Go install mysql
SQL
0 vote198 views1 answer
Rename constraint postgresql
SQL
0 vote231 views1 answer
Sql convert unix time to date
SQL
0 vote263 views1 answer
Sql alter table add column if exists
SQL
13 votes144 views2 answers
Oracle all source
SQL
1 vote194 views1 answer
Sql pick random row
SQL
0 vote200 views1 answer
Sql check if column exists
SQL