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

1 vote137 views1 answer
Mysql get domain from url
SQL
2 votes151 views1 answer
Sql server find columns list in tables
SQL
2 votes136 views1 answer
Mysql set value as null
SQL
0 vote127 views2 answers
Nosqlbooster query other collection
SQL
0 vote177 views1 answer
Display all node label neo4j
SQL
1 vote135 views6 answers
In sql
SQL
3 votes132 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
7 votes135 views1 answer
Safe update mysql
SQL
0 vote106 views1 answer
Sql table to store status
SQL
0 vote213 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL