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 vote255 views1 answer
View to table
SQL
0 vote259 views1 answer
Python mysql query to dataframe
SQL
0 vote264 views1 answer
Open postgresql.conf in centos
SQL
0 vote250 views1 answer
Select count postgres double row count > 1
SQL
1 vote336 views1 answer
Sql and
SQL
27 votes255 views4 answers
Get all tables with column name sql
SQL
0 vote248 views1 answer
Sql max min
SQL
0 vote285 views1 answer
Make parameters nullable in sql server
SQL
0 vote245 views1 answer
How to query all tables mysql at the same time
SQL
0 vote278 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL