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 vote313 views1 answer
Find and replace query in wordpress\
SQL
6 votes280 views2 answers
Find mysql version linux
SQL
0 vote290 views1 answer
Ubuntu stop mysql from starting on boot
SQL
1 vote280 views3 answers
How to update column name in psql
SQL
2 votes279 views2 answers
Mysql user access to database
SQL
0 vote286 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
3 votes285 views1 answer
Null sql
SQL
0 vote272 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote291 views1 answer
How to generate ids in sql
SQL
0 vote353 views1 answer
Current month transactions in mysql
SQL