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 votes202 views1 answer
SQL column name Postgre
SQL
0 vote198 views1 answer
Oracle running queries sql
SQL
0 vote240 views1 answer
For select oracle
SQL
2 votes236 views1 answer
How to get non distinct values in sql
SQL
0 vote207 views2 answers
How to drop mili second in sql
SQL
0 vote205 views1 answer
Difference between db.query and db.execute
SQL
0 vote216 views1 answer
Enable outgoing remote MySQL access
SQL
4 votes180 views4 answers
Date less than in sql
SQL
4 votes194 views6 answers
List all tables in postgres
SQL
10 votes186 views1 answer
Oracle object dependencies
SQL