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

0 vote121 views1 answer
Vowels in sql
SQL
0 vote131 views4 answers
How to drop all tables in sql
SQL
0 vote139 views1 answer
Check database restore status sql script
SQL
3 votes122 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote121 views1 answer
Cross apply top for each row t1
SQL
0 vote124 views1 answer
Foreign key type uniqu mysql
SQL
1 vote125 views1 answer
Oracle user last connected
SQL
-1 vote119 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote136 views1 answer
Oracle last connexion
SQL
5 votes136 views1 answer
How to use rank function in sql
SQL